DBA Hub

📋Steps in this guide1/1

Add/Drop/Alter datafile

-- Add a datafile to a tablespace

oracle configurationintermediate
by OracleDba
12 views
1

Add/Drop/Alter datafile

-- Add a datafile to a tablespace -- Enable autoextend on for a datafile; -- Resize a datafile -- Make a datafile offline/online -- Drop a datafile:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
Alter tablespace USERS add datafile '/u01/data/users02.dbf' size 5G;
Alter database datafile '/u01/data/users02.dbf' autoextend on;
alter database datafile '/u01/data/users02.dbf' resize 10G;
Alter database datafile '/u01/data/users02.dbf' offline;
Alter database datafile '/u01/data/users02.dbf' online;
Alter tablespace USERS drop datafile '/u01/data/users02.dbf';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!