datapump

Importing a dmp file created by DataPump into Oracle Express 10g

How do i go about importing a .dmp file created by DataPump into Oracle Express 10g ...

Oracle Export Datapump issues

Hi all, I have a problem with import certain specified tables using expdp command in oracle 10g. Here's what i did to set it up: I logged in as sysdba and ran the following commands create or replace directory dumpdir as 'c:\test\'; grant read,write on directory dumpdir to test; Then i went to the command prompt on my windows box a...

Oracle Data Pump import to a sql file error :ORA-31655 no data or metadata objects

Hello, I'm using Data Pump to export/import data, one requirement is to import data to a sql file. The OS is window. I made the follow export : expdp system/password directory=dpump_dir dumpfile=tablesdump.dmp content=DATA_ONLY tables=user.tablename and it works, I can see the file TABLESDUMP.DMP in the directory path. then when I tr...

How to use Data Pump (expdp and impdp) commands from Oracle without tnsnames.ora file

I want to be able to run expdp and impdp onto a machine by directly specifying the connection parameters instead of a tns name that resides in tnsnames.ora. Is this possible? ...

Return code/ exit code for Oracle's DataPump API

I wrapped oracle's IMPDP and EXPDP in a console and could not find a good place for the return codes that these two return. I want to be more specific in pointing out errors than just a 0/1 Pass/Fail. ...

Lot of time spent with following waits 'SQL*Net message from client' and 'wait for unread message on broadcast channel'

My application that wraps around Oracle Data pump's executables IMPDP and EXPDP takes random amounts of time for the same work. On further investigation, I see it waiting for again random amounts of time with the event 'wait for unread message on broadcast channel'. This makes the application take anytime b/w 10 minutes to over an hour f...

Can the arguments BUFFER and DIRECT be used with expdp

I have a strange case where in what this guy says is not happening with me. I am not able to set the above two parameters neither through command line directly, nor using a par file. expdp -help doesn't show any such arguments, so are there analogous arguments to BUFFER and DIRECT (from exp) in the data-pump version. ...

Oracle Data Pump Export script help

Hi, I'm trying to do a data pump export for metadata on a tablespace (COURSE). Am I on the right track? My data pump directory was created as: CREATE DIRECTORY dpump_dir AS '/mydata/data'; Please keep in mind that I'm a beginner. This may or may not be the best way to go about this, but I'd like to try to get this working. Thanks very ...