Phone: +86 13764045638 Email: service@parnassusdata.com 7 x 24 online support!

    You are here

Please help production system drop tablespace and forget export before

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:
 
BEGIN
DBMS_TTS.TRANSPORT_SET_CHECK(ts_list => 'DOCS_VMP_BLOB', incl_constraints => TRUE);
END;
 
SELECT * FROM TRANSPORT_SET_VIOLATIONS
There are no rows.
 
ALTER TABLESPACE DOCS_VMP_BLOB READ ONLY;
ok.
 
!! 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
 
and made
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.
Thanks.
 
 
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/