오라클 TABLESPACE 생성
CREATE [DISK] [DATA] TABLESPACE tablespace_name
DATAFILE 'datafile_name'
[SIZE size (K | M | G) ] [REUSE]
[AUTOEXTEND [ON [NEXT size][MAXSIZE size ] | OFF)];
--------------------------------------------------------
# sqlplus /nolog
SQL> connect /as sysdba
Connected.
SQL>
CREATE TABLESPACE TEST_TABLE_TS
DATAFILE '/export/home/oracle/oraapp/product/oradata/orcl/TEST_TABLE_TS.dbf'
AUTOEXTEND ON
/
ORA-01119: error in creating database file
'/export/home/oracle/oraapp/product/oradata/orcl/TEST_TABLE_TS.dbf'
ORA-17610: file
'/export/home/oracle/oraapp/product/oradata/orcl/TEST_TABLE_TS.dbf' does not
exist and no size specified
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
SQL> quit
--------------------------------------------------------
오류원인을 찾아보니 테이블스페이스의 SIZE를 설정해주지 않아서 발생한 문제인것으로 확인되었다..
http://ora-01119.ora-code.com/
ORA-01119: error in creating database file 'string'
Cause: Usually due to not having enough space on the device.
Action: none
http://ora-17610.ora-code.com/
ORA-17610: file 'string' does not exist and no size specified
Cause: An attempt to create a file a file found neither an existing file nor a size for creating the file.
Action: Specify a size for the file.
--------------------------------------------------------
SQL>
CREATE TABLESPACE TEST_TABLE_TS
DATAFILE '/export/home/oracle/oraapp/product/oradata/orcl/TEST_TABLE_TS.dbf'
SIZE 100M
AUTOEXTEND ON
/
Tablespace created.
정상적으로 생성이 확인된다.
--------------------------------------------------------