SQL> create bigfile tablespace bigts
datafile '/u02/app/oracle/ssss/bigts01.dbf'
size 2m;
SQL> select tablespace_name,block_size,status,contents,bigfile from dba_tablespaces;
SQL> select file_name,file_id,tablespace_name,bytes from dba_data_files;
No comments:
Post a Comment