2 added 257 characters in body
source | link

No, you just can't copy and paste datafiles.

In order to do so, you must first export (with exp/imp tools) the tablespace as a transportable tablespace, then copy the datafiles, and finally import the dump file generated in the export process. But note that this wont work between different platforms (that feature is from 10g on ahead)

Instead, you can just export the whole tablespace (or schema) into a dump file and then, create same schema and tablespaces as you did, and then import it.

-- Edit -- In that case, If you still have a backup of the controlfiles, you can take them plus the needed files, put in the same locations, create a pfile, start mount, take offline all datafiles except those you want, open DB, and export the table.

No, you just can't copy and paste datafiles.

In order to do so, you must first export (with exp/imp tools) the tablespace as a transportable tablespace, then copy the datafiles, and finally import the dump file generated in the export process. But note that this wont work between different platforms (that feature is from 10g on ahead)

Instead, you can just export the whole tablespace (or schema) into a dump file and then, create same schema and tablespaces as you did, and then import it.

No, you just can't copy and paste datafiles.

In order to do so, you must first export (with exp/imp tools) the tablespace as a transportable tablespace, then copy the datafiles, and finally import the dump file generated in the export process. But note that this wont work between different platforms (that feature is from 10g on ahead)

Instead, you can just export the whole tablespace (or schema) into a dump file and then, create same schema and tablespaces as you did, and then import it.

-- Edit -- In that case, If you still have a backup of the controlfiles, you can take them plus the needed files, put in the same locations, create a pfile, start mount, take offline all datafiles except those you want, open DB, and export the table.

1
source | link

No, you just can't copy and paste datafiles.

In order to do so, you must first export (with exp/imp tools) the tablespace as a transportable tablespace, then copy the datafiles, and finally import the dump file generated in the export process. But note that this wont work between different platforms (that feature is from 10g on ahead)

Instead, you can just export the whole tablespace (or schema) into a dump file and then, create same schema and tablespaces as you did, and then import it.