-
Has anybody got this error?
I am using this package dbms_space_admin.TABLESPACE_MIGRATE_TO_LOCAL
ORA-00406: COMPATIBLE parameter needs to be 8.1.6.0.0 or greater
Thanks
Shailendra
-
It seems this dbms_space_admin.TABLESPACE_MIGRATE_TO_LOCAL is used only in 8.1.6 .
just change the compatibility prameter in init.ora file and restart the database .
hopefully u can use this package .
siva prakash
DBA
-
check what is COMPATIBLE parameter set for your instance
SQL> show parameter COMPATIBLE
and if it is not 8.1.6.0.0 or greater the set it
shutdown database
change init.ora
add or edit
COMPATIBLE = 8.1.6.0.0
restart the database
HTH
Sameer
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|