How to add tablespace in oracle

 Run this command in instance what you add tablespace

"alter tablespace SYSTEM add datafile '/data/u01/app/oracle/oradata/ICNPRODB/system03.dbf' size 1000M autoextend on;"

note : /data/u01/app/oracle/oradata/ICNPRODB/system03.dbf is directory tablespace you've been create

Posting Komentar

Lebih baru Lebih lama