Database Administration (MOSC)

MOSC Banner

How to create tablespace for pluggable database with out oracle GUID in directory structure

edited Nov 22, 2018 3:22AM in Database Administration (MOSC) 4 commentsAnswered

Hello folks.

I have done lot of reading on this topic with not much success, I am hoping someone can help me please.

I'd like to create pluggable database with default tablespace datafile created in pdb directory without oracle created guid.

I'd like to organize my dbfiles as +DATA/CDB/pdb,,so I issued following statment

SQL> create pluggable database test admin user testuser identified by userpw file_name_convert = ('/pdbseed/','/test/');
create pluggable database test admin user testuser identified by userpw file_name_convert = ('/pdbseed/','/test/')
*
ERROR at line 1:
ORA-65005: missing or invalid file name pattern for file -

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center