Oracle Set table space not Limited
1. View each table space status
SELECT file_name,tablespace_name,autoextensible from Dba_data_files;
2. The table space is infinitely large
alter DATABASE datafile '/U02/ORADATA/RSJDB/USERS01.DBF ' autoextend on MaxSize Unlimited;
3. Table space, table
sql> create tablespace tbs01 datafile ' d:\orcl\tbs01.dbf ' size 1M autoextend on
next 512K maxsize Unli Mited Logging Extent management Local segment space manage
ment auto;
The table space has been created.
sql> CREATE TABLE SCOTT.TAB01 (c int) tablespace tbs01;
Table has been created.
sql> CREATE TABLE SCOTT.TAB02 (c int) tablespace TBS02;
Table has been created.
sql> INSERT INTO SCOTT.TAB01 values (1);
1 lines have been created.
sql> INSERT INTO SCOTT.TAB01 values (2);
1 lines have been created.
sql> INSERT INTO SCOTT.TAB02 values (1);
1 lines have been created.
sql> INSERT INTO SCOTT.TAB02 values (2);
1 lines have been created.
sql> commit;
Submit completed.