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 ...
How do i go about importing a .dmp file created by DataPump into Oracle Express 10g ...
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...
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...
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? ...
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. ...
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...
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. ...
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 ...