Saturday, May 24, 2025

How to create tablespace in oracle database ?

 

SQL>

SQL>  create tablespace rcat datafile '/u01/app/oracle/oradata/DB2/rcat.dbf' size 15M;


Tablespace created.


SQL>

No comments:

Post a Comment

what is catcon.pl (Catalog Container Script) and why very useful for Oracle Multitenant Database ?

  catcon.pl (Catalog Container Script) is an Oracle utility introduced with the Multitenant Architecture (CDB/PDB) to execute SQL scripts ...