ORA-00406: COMPATIBLE parameter

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 .

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

thanks guys

shailendra