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-DULDBRECOVER for Oracle

DBRECOVER Recovery Options

For Oracle incidents, start with the DBRECOVER for Oracle trial to verify table visibility, row previews, and export readiness on copied datafiles. For MySQL and InnoDB incidents, DBRECOVER for MySQL is free software and can inspect.ibd files, ibdata1, and database directories locally.

When the case is urgent, preserve the original files first, work from copies, and contact paid emergency support with the database version, platform, error messages, file list, and recovery objective.