Home » RDBMS Server » Server Administration » ORA-01658: unable to create INITIAL extent for segment in tablespace for the source TS (ORACLE 11g windowsxp)
ORA-01658: unable to create INITIAL extent for segment in tablespace for the source TS [message #519415] |
Thu, 11 August 2011 23:44  |
prejib
Messages: 126 Registered: March 2009 Location: India
|
Senior Member |
|
|
I have executed the below statement to move a bulk of table from source table space-SHOP3_DATA to destination tablespace -LINUX_CATA. Before executing the statement the source table space was having 85% full message . While executing the statement this is giving the error for the source tablespace means the the tablespace is getting consumed in the source TS. Currently no-one is using the tablespace SHOP3_DATA' . If I add datafile to the SHOP3_DATA the problem may be solved but why the space is getting consumed in the source. Now the tablespace SHOP3_DATA is 95% full
SQL> alter table LINUX_CATA.TST_FOLDERS move tablespace LINUX_CATA;
Table altered.
SQL> alter table LINUX_CATA.TST_SEARCH_TESTS move tablespace LINUX_CATA;
alter table LINUX_CATA.TST_SEARCH_TESTS move tablespace LINUX_CATA
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace SHOP3_DATA
SQL> alter table LINUX_CATA.TST_TEST_TYPES move tablespace LINUX_CATA;
alter table LINUX_CATA.TST_TEST_TYPES move tablespace LINUX_CATA
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace SHOP3_DATA
|
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Jun 09 16:20:58 CDT 2025
|