国产成人精品久久免费动漫-国产成人精品天堂-国产成人精品区在线观看-国产成人精品日本-a级毛片无码免费真人-a级毛片毛片免费观看久潮喷

您的位置:首頁技術(shù)文章
文章詳情頁

Oracle的PDB數(shù)據(jù)庫創(chuàng)建DIRECTORY時(shí)遇到ORA-65254問題及解決方法

瀏覽:117日期:2023-09-18 20:52:31

在Oracle 19c多租戶環(huán)境的PDB數(shù)據(jù)庫下面創(chuàng)建一個(gè)DIRECTORY時(shí),遇到了“ORA-65254: invalid path specified for the directory”,下面簡單演示一下所遇到的這個(gè)案例

SQL>?CREATE?PLUGGABLE?DATABASE?PDB6?ADMIN?USER?pdbadmin?IDENTIFIED?BY?hqLDJ7236#4U8JHD??2??STORAGE?(MAXSIZE?1G?MAX_SHARED_TEMP_SIZE?2G)??3??DEFAULT?TABLESPACE?TEST?DATAFILE?'/db19c/oracle_data/PDB6/test_data_01.dbf'?SIZE?100M??4??PATH_PREFIX?='/db19c/oracle_data/PDB6/'??5??FILE_NAME_CONVERT=('/db19c/CTEST/pdbseed/','/db19c/oracle_data/PDB6/');Pluggable?database?created.SQL>?SQL>?alter?pluggable?database?pdb6?open;Pluggable?database?altered.SQL>?alter?session?set?container=PDB6;Session?altered.SQL>?CREATE?OR?REPLACE?DIRECTORY?EXP_DUMP?AS?'/db19c/exp_dump';CREATE?OR?REPLACE?DIRECTORY?EXP_DUMP?AS?'/db19c/exp_dump'*ERROR?at?line?1:ORA-65254:?invalid?path?specified?for?the?directory##注意,創(chuàng)建DIRECTORY時(shí),這個(gè)目錄/db19c/exp_dump已經(jīng)存在。SQL>?SQL>?!oerr?ora?6525465254,?00000,?'invalid?path?specified?for?the?directory'//?*Cause:???An?absolute?path?was?used?in?the?CREATE?DIRECTORY?statement.?//???????????Since?the?PDB?has?set?the?PATH_PREFIX?property,?only?relative//???????????path?is?allowed?for?directories.//?*Action:??Specify?a?relative?path?and?reissue?the?statement.//SQL>

如上所示,數(shù)據(jù)庫提示,出現(xiàn)這個(gè)錯(cuò)誤的原因在于創(chuàng)建PDB的語句中指定了PATH_PREFIX參數(shù),創(chuàng)建目錄DIRECTORY時(shí)只能使用相對路徑,而不能使用絕對路徑。其實(shí)創(chuàng)建PDB時(shí),如果設(shè)置了PATH_PREFIX參數(shù),那么這個(gè)PDB中的所有對象只能限定在PATH_PREFIX指定的路徑下,,只能指定基于PATH_PREFIX的相對路徑。官方文檔關(guān)于這個(gè)的解釋如下所示:

Restrictions on PDB File Locations

The PATH_PREFIX clause of the CREATE PLUGGABLE DATABASE statement ensures that all directory object paths associated with the PDB are restricted to the specified directory or its subdirectories. This clause also ensures that the following files associated with the PDB are restricted to the specified directory: the Oracle XML repository for the PDB, files created with a CREATE PFILE statement, and the export directory for Oracle wallets. Use this clause when you want to ensure that a PDB's files reside in a specific directory and its subdirectories. You can use this clause to specify one of the following options:

An absolute path that is used as a prefix for all file paths associated with the PDB.

The name of a directory object that exists in the CDB root (CDB$ROOT). The directory object points to the absolute path to be used for PATH_PREFIX.

NONE to indicate that there are no restrictions for the file paths. Omitting the PATH_PREFIX clause is the same as specifying NONE.

After a PDB is created, its PATH_PREFIX setting cannot be modified.

也就是說,如果我要?jiǎng)?chuàng)建一個(gè)目錄,只能使用相對路徑的目錄,而且必須在PATH_PREFIX指定的/db19c/oracle_data/PDB6/下面,想指定到其他路徑,例如/db19c/exp_dump.此時(shí)就會(huì)拋出ORA-65254錯(cuò)誤。

解決方法SQL>?CREATE?OR?REPLACE?DIRECTORY?EXP_DUMP?AS?'exp_dump';Directory?created.SQL>?SET?LINESIZE?1080;SQL>?COL?OWNER?FOR?A16;SQL>?COL?DIRECTORY_NAME?FOR?A30;SQL>?COL?DIRECTORY_PATH?FOR?A64;SQL>?SELECT?*?FROM?DBA_DIRECTORIES;OWNER??????DIRECTORY_NAME???????DIRECTORY_PATH?????????????????ORIGIN_CON_ID-------?------------------?-----------------------------------?-------------SYS??????????????EXP_DUMP???/db19c/oracle_data/PDB6/exp_dump???

關(guān)于這種問題,如果在創(chuàng)建PDB數(shù)據(jù)庫時(shí),不設(shè)定參數(shù)PATH_PREFIX就不會(huì)遇到這個(gè)問題。一般沒有特殊要求,也不用設(shè)定參數(shù)PATH_PREFIX。

到此這篇關(guān)于Oracle的PDB數(shù)據(jù)庫創(chuàng)建DIRECTORY時(shí)遇到ORA-65254的文章就介紹到這了,更多相關(guān)Oracle的PDB數(shù)據(jù)庫內(nèi)容請搜索好吧啦網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持好吧啦網(wǎng)!

標(biāo)簽: Oracle 數(shù)據(jù)庫
主站蜘蛛池模板: 一级毛片在线完整免费观看 | 永久免费不卡在线观看黄网站 | 久久精品一品道久久精品9 久久精品一区 | 欧美日韩亚洲一区二区三区 | 亚洲在线小视频 | 久草免费资源视频 | 免费一级毛片不卡在线播放 | 97午夜影院 | 国产成人精品男人的天堂网站 | 日本三级成人中文字幕乱码 | 成人a在线观看 | 日本加勒比一区 | 久久久免费视频观看 | 亚洲伊人色综合网站亚洲伊人 | 日产一区二区三区四区 | 成人一级毛片 | 精品视频一区二区三区 | 免费观看欧美一级毛片 | aa毛片免费全部播放完整 | 日本一区二区三区在线 视频观看免费 | 欧美一区二区三区久久久人妖 | 韩国精品欧美一区二区三区 | 国产成人亚洲综合91精品555 | 亚洲欧美日韩国产精品26u | 久久久久久国产精品免费免 | 亚洲视频男人的天堂 | 国产精品久久免费视频 | 色射网 | 欧美第一页草草影院浮力 | 欧美一级高清片免费一级 | 久久成年片色大黄全免费网站 | 毛片免费在线 | 91香蕉成人免费高清网站 | 亚洲视屏在线观看 | 亚洲精品一区二区三区网址 | 欧美精品xxx| 国产亚洲精品线观看77 | 日本三级香港三级妇三 | 欧美日韩国产一区二区三区在线观看 | 亚洲欧美激情精品一区二区 | 一道精品视频一区二区三区图片 |