你在这里

You are here:

首页

博客

PDSERVICE的博客

Please help production system drop tablespace and forget export before

Posted by PDSERVICE on 4月 18, 2017 In

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/