테이블스페이스를 만들려고 skfuserts.sql을 실행시켰을때 다음과
같은 에러가 나타납니다.
@c:\skfuserts.sql;
create tablespace skfuser
*
ERROR at line 1:
ORA-01543: tablespace 'SKFUSER' already exists
Database altered.
Tablespace altered.
Create Tablespace lob_seg_ts
*
ERROR at line 1:
ORA-01119: error in creating database file
'C:\oracle\oradata\cmserver\lobts1.dbf'
ORA-27038: skgfrcre: file exists
OSD-04010: <create> option specified, file already exists
ALTER DATABASE DATAFILE 'C:\oracle\oradata\cmserver\LOBTS1.DBF'
AUTOEXTEND ON MAXSIZE UNLIMITED
*
ERROR at line 1:
ORA-01516: nonexistent log file, datafile or tempfile
'C:\oracle\oradata\cmserver\LOBTS1.DBF'
ALTER DATABASE DATAFILE 'C:\oracle\oradata\cmserver\LOBTS2.DBF'
AUTOEXTEND ON MAXSIZE UNLIMITED
*
ERROR at line 1:
ORA-01516: nonexistent log file, datafile or tempfile
'C:\oracle\oradata\cmserver\LOBTS2.DBF'
ALTER TABLESPACE LOB_SEG_TS ONLINE
*
ERROR at line 1:
ORA-00959: tablespace 'LOB_SEG_TS' does not exist
Tablespace altered.
Tablespace altered.
Database altered.
Tablespace altered.
SQL> exit
어떻게 하면 좋을까요?
|