Please help production system drop tablespace and forget export before
Hello.
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.