OraFAQ Forum: Server Administration » sys.dbms_space_admin .tablespace_migrate_to

Home » RDBMS Server » Server Administration » sys.dbms_space_admin .tablespace_migrate_to_local

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sys.dbms_space_admin .tablespace_migrate_to_local [message #164403]

Thu, 23 March 2006 05:43

AlinaC
Messages: 45
Registered: November 2005
Location: India

Member

I have to convert dictionary managed tablespace to locally managed tablespace

trying to execute as
exec sys.dbms_space_admin .tablespace_migrate_to_local('tablespace_name')

but error reported as
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.DBMS_SPACE_ADMIN' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Pl. help to convert locally managed tablespace. using oracle 9i

Regards,
Alina

Report message to a moderator

Re: sys.dbms_space_admin .tablespace_migrate_to_local [message #164413 is a reply to message #164403]

Thu, 23 March 2006 06:13

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Why not continue in the same thread?
Flooding the forums with multiple postings will not help anything.

Report message to a moderator

Re: sys.dbms_space_admin .tablespace_migrate_to_local [message #164414 is a reply to message #164403]

Thu, 23 March 2006 06:15

AlinaC
Messages: 45
Registered: November 2005
Location: India

Member

sorry I thaught Server Administration and Performance Tuning are two seperate groups.

Sorry

Report message to a moderator

Re: sys.dbms_space_admin .tablespace_migrate_to_local [message #164419 is a reply to message #164414]

Thu, 23 March 2006 06:23

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Both are different forums. But you are cross-posting the same message across different forums and not continuing with the same thread.

Report message to a moderator

Re: sys.dbms_space_admin .tablespace_migrate_to_local [message #164433 is a reply to message #164419]

Thu, 23 March 2006 07:24

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

And your postings are all over the web.
Just got the feeds on ITTOOLBOX?

Report message to a moderator

Previous Topic:	error while executing DBMS_STATS.GATHER_SCHEMA_STATS
Next Topic:	Sys information

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:42:23 CDT 2024