When the rollback segment tablespace (RBS) was convered from dictionary managed to local managed in Oracle8i, exporting the full database might produce the error of EXP-00003: no storage definition found for segment(2,2).
If this is the case, you can convert the RBS back to the dictionary-managed tablespace by executing the SQL command:
exec dbms_space_admin.tablespace_migrate_from_local('RBS');
Then re-run the export command:
SET ORACLE_SID=testdb
exp sys/dba full=y direct=y buffer=100000000 file=d:\export\testdb.dmp log=d:\export\testdb.log
If this is the case, you can convert the RBS back to the dictionary-managed tablespace by executing the SQL command:
exec dbms_space_admin.tablespace_migrate_from_local('RBS');
Then re-run the export command:
SET ORACLE_SID=testdb
exp sys/dba full=y direct=y buffer=100000000 file=d:\export\testdb.dmp log=d:\export\testdb.log
文章標籤
全站熱搜
