Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

Fail to create pdb from PDB$SEED under ASM

edited Jan 1, 2014 10:45AM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 4 commentsAnswered
--Information about PDB$SEED's datafiles and tempfiles
SQL>select * from cdb_data_files where con_id=2;
FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_STATUS CON_ID
+DATADG1/ORA12C/DD7C48AA5A4404A2E04325AAE80A403C/DATAFILE/system.269.828826479 5 SYSTEM 272629760 33280 AVAILABLE 1 YES 34359721984 4194302 1280 271581184 33152 SYSOFF 2
+DATADG1/ORA12C/DD7C48AA5A4404A2E04325AAE80A403C/DATAFILE/sysaux.268.828826479 7 SYSAUX 702545920 85760 AVAILABLE 4 YES 34359721984 4194302 1280 701497344 85632 OFFLINE 2

SQL>select * from cdb_data_files where con_id=1;
FILE_NAME FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUTOEXTENSIBLE MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS CON_ID

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