REORGANIZATION FAILED
Hi Guys,
I am trying to regoranize my tablespace using 11g database control but its failing during execution since every thing is automatic I can't get my head around why its giving my sytnax error. I see no errors / warnings before execution process. Do you think its a bug in 11.1.0.6. I can't find any thing related on metalink.
please see blow:
Many Thanks
Faisal
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jul 28 12:19:25 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> Connected.
SQL> -- Target database: fadw
-- Script generated at: 28-JUL-2010 12:15
Starting reorganization
Executing as user: SYS
CREATE SMALLFILE TABLESPACE "TS_MYTABLESPACE_REORG0" DATAFILE
I am trying to regoranize my tablespace using 11g database control but its failing during execution since every thing is automatic I can't get my head around why its giving my sytnax error. I see no errors / warnings before execution process. Do you think its a bug in 11.1.0.6. I can't find any thing related on metalink.
please see blow:
Many Thanks
Faisal
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Jul 28 12:19:25 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> Connected.
SQL> -- Target database: fadw
-- Script generated at: 28-JUL-2010 12:15
Starting reorganization
Executing as user: SYS
CREATE SMALLFILE TABLESPACE "TS_MYTABLESPACE_REORG0" DATAFILE
0