반응형

 

오라클 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.


정상적으로 생성이 확인된다.

--------------------------------------------------------

 

 

 

 

 

 

반응형
Posted by 공간사랑
,