Solution : https://service.sap.com/sap/support/notes/594601 (SAP Service marketplace login required)
Key words :
/oracle/t01/sapdata1/cntrl /oracle/t01/sapdata2/cntrl /oracle/t01/sapdata3/cntrl /oracle/t01/sapdata1/system_1 /oracle/t01/sapdata1/roll_1 /oracle/t01/sapdata2/user1d_1 /oracle/t01/sapdata2/user1d_2 /oracle/t01/sapdata2/user1d_3 /oracle/t01/saparch /oracle/t01/saptrace /oracle/t01/saptrace/background note, setenv oracle_sid t01 setenv sapdata_home /oracle/t01step 4, question exp sapr3/<passwd> tables=<table_name> file=<table_name>, oracle software installedthe table, ------------------------t01, sql> set linesize 132 pagesize 30000 sql> spool df_offline, terms recreate table user error reason, sql sql> select 'alter database datafile ', - sql> alter database open resetlogs, - sql> alter database open
Related Notes :
605062 | FAQ: Restore and recovery |