Monday , December 4 2023

Importing Objects From A Different Tablespace

We can import an object from the database to a different database and a different tablespace with a different schema.

1. First, let’s get this done using the data transfer method.

If we question the result.

2. We can export the table and export it to a different schema and tablespace.

First, let’s “export” a table from the database named “cc”.

Then we send the “DUMP” file to the data_dump_dir folder of the database named “catalog” with scp.

Let’s “import” to our database named “catalog”.




Leave a Reply

Your email address will not be published. Required fields are marked *