HuyPV
Thursday, September 9, 2010
create tablespace
users
datafile
'/ora01/oracle/oradata/booktst_users_01.dbf'
size
50m
autoextend on
next 10m
maxsize 100m;
alter database datafile 'E:\oracle\product\10.2.0\oradata\orcl\ADSL_01.DBF' autoextend on next 100m maxsize 15G
ALTER DATABASE DATAFILE '/path/to/data/file/name' RESIZE 200M;
ALTER TABLESPACE ADSL
ADD DATAFILE 'E:\oracle\product\10.2.0\oradata\orcl\ADSL_02.DBF' SIZE 100M autoextend on next 300M maxsize unlimited;
Title:
Oracle Working with tablesapce and datafile
Description:
create tablespace users datafile '/ora01/oracle/oradata/booktst_users_01.dbf' size 50m autoextend on next 10m maxsi...
...
Rating:
4