| Kaiz |
Posted: Feb 14, 2008 01:26:32 PM |
Total Post: 104
Joined: Sep, 2007
|
Friends,
When I was trying to change the extent management of system tablespace from Dictionary to Local by giving the following command....
dbms_space_admin.tablespace_migrate_to_local('SYSTEM');
I got this error...
SP2-0734:unknown command beginning "dbms_space…"- rest of line ignored
Do any one know about this problem....
with Regards...
|
|
|
 MOH_DBA |
| Posted: Feb 14, 2008 03:48:41 PM |  |
|
Total Post: 124
Joined: Nov, 2007
|
Check for spaces in your script and package.
|
|
|
|
|
| Murtuja |
| Posted: Feb 14, 2008 11:23:35 PM | |
|
Total Post: 814
Joined: Jan, 2006
|
Hi,
SQL> execute DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL ('SYSTEM');
|
|
|
|
|
| Kaiz |
| Posted: Feb 15, 2008 08:40:28 AM | |
|
Total Post: 104
Joined: Sep, 2007
|
Thanks, It worked...
and thanks above all for quick reply...
Please keep it up...Friends you are great help for a new DBAs Like us..
I appreciate....
With Regards...
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
