1

I have a multiple databases i.e (database1,database2) and i need to export a table from database1 to database2 . Here are the commands i tried

expdp hr/oracle@oracle tables=emp directory = ora dumpfile=emp.dmp 

This command will export the the emp.dmp file to "ora" directory but i need to import this dump file to another database but the "ora" directory is not accessible to the database2 . Do we have any other method to export the database dump .

closed as unclear what you're asking by Balazs Papp, hot2use, mustaccio, RDFozz, Erik Darling Sep 18 '17 at 23:02

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • Where are the databases? Same or different server? Same instance or different instance? Windows or Linux? How did you define the Export directory? Please provide as much information as possible. – hot2use Sep 18 '17 at 5:40
0

So? Just copy a dumpfile to a location accessible to database2.

ora is not a directory, it is a directory object defined in the database, that serves as an "alias" to the real path in the filesystem.

Overview of Oracle Data Pump

File Allocation

Data Pump is server-based rather than client-based, dump files, log files, and SQL files are accessed relative to server-based directory paths. Data Pump requires that directory paths be specified as directory objects. A directory object maps a name to a directory path on the file system.

The following example shows a SQL statement that creates a directory object named dpump_dir1 that is mapped to a directory located at /usr/apps/datafiles.

SQL> CREATE DIRECTORY dpump_dir1 AS '/usr/apps/datafiles';

Or you can import the table directly from database1 to database2 through a database link.

Using Network Link Import to Move Data

When the Import NETWORK_LINK parameter is used to specify a network link for an import operation, SQL is directly used to move the data using an INSERT SELECT statement. The SELECT clause retrieves the data from the remote database over the network link. The INSERT clause uses SQL to insert the data into the target database. There are no dump files involved.

Not the answer you're looking for? Browse other questions tagged or ask your own question.