Phone: +86 13764045638 Email: email@example.com 7 x 24 online support!
Please help production system drop tablespace and forget export before
There is one table was in bigfile tablespace. one file, one table, one tablespace.
It was planned make transportable tablespace and move it into another hard drive.
I made next steps:
DBMS_TTS.TRANSPORT_SET_CHECK(ts_list => 'DOCS_VMP_BLOB', incl_constraints => TRUE);
SELECT * FROM TRANSPORT_SET_VIOLATIONS
There are no rows.
ALTER TABLESPACE DOCS_VMP_BLOB READ ONLY;
!! And here it was neccessary EXPort, but I forget
EXP 'sys/ххххххххх' TRANSPORT_TABLESPACE=Y TABLESPACES=(DOCS_VMP_BLOB) LOG = EXP_LOG.log CONSTRAINTS=N GRANTS=Y TRIGGERS=Y FILE=DOCS_VMP_BLOB.DMP
drop tablespace DOCS_VMP_BLOB including contents;
And now I dont't have export dump. No rows in oracle dictonary about this tablespace.
I just have file on OS.
Please help me, I just have 20-30 minutes to restore it, or my life is ended.
You can try this option:
Manually extract the data using the Oracle's Data Unloader (DUL), which is performed by Oracle Field Support at the customer site on the next business day and for an extra charge. (Call Oracle Support).
or you can try dul alternative : PRM-DUL http://www.parnassusdata.com/