Create:
CREATE TABLESPACE DATA05 DATAFILE 'D:\app_db12c\oracle\oradata\orcl\sample01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1M;
Extend:
ALTER TABLESPACE DATA05 ADD
DATAFILE 'D:\app_db12c\oracle\oradata\orcl\sample02.dbf' SIZE 1M
AUTOEXTEND ON NEXT 1M;
Delete:
DROP TABLESPACE DATA05 INCLUDING CONTENTS AND DATAFILES;
Table space leads to the diagrammatically differences. as the large content included when it is necessary the table alignment changes how to overcome this problem is discussed here very clearly thank you.
ReplyDeleteOracle Fusion Cloud HCM Online Training
Nice blog,thank you for your valuable information.For more information please visit our website.
ReplyDeleteOracle Fusion Cloud HCM Training