trying to do a full databse export using datapump;the export file gets generated on the server side.
how do I generate the export file on the client side as I need to use the full export file to c...
http://www.experts-exchange.com/Database/Oracle/Q_24274568.html
Zones:
OracleDate Answered: 04/06/2009 Rating: 8.4 Views: 0
I am running impdp on a file to import a schema into my tablespace. My tablespace is called DEMO. The impdp command I am running is:
impdp DEMOUSER/DEMOUSER@dev dumpfile=AR_TABLES.dmp logfile=AR...
http://www.experts-exchange.com/Database/Oracle/Q_24305669.html
Zones:
Oracle,
Ora...Date Answered: 04/15/2009 Rating: 7.6 Views: 267
I want to use the SYS.dbms_datapump package to import a SINGLE table from another database. I know that there is a client that can be called to initiate the datapump, but I dont want to call the c...
http://www.experts-exchange.com/Database/Oracle/Q_23918002.html
Hello,
I am attempting to export data to a mapped Microsoft drive. When I perform the export I get the error shown in the code snippet.
I have done the following:
1. Mapped the drive to the...
http://www.experts-exchange.com/Database/Oracle/Q_23812882.html
Zones:
Oracle,
...Date Answered: 10/15/2008 Rating: 9.8 Views: 96
Hi guys,
I'm struggling to imporve datapump import speed (local, not via network or dblink), doing no benefit, have tried these options:
parallel = 1 -> 3 hrs & 42 mins (no parallel is better...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_24385077.html
Zones:
Oracle 10.xDate Answered: 06/09/2009 Rating: 7.1 Views: 0
Hi guys,
Back to you ... again ;-)
Import was happening absolutely perfect till Saturday, and from Monday it is taking more then double the time ... where as it usually completed by Morning,...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_24664755.html
Zones:
Oracle 10.xDate Answered: 08/24/2009 Rating: 8.5 Views: 0
Hello, I need to export an Oracle 10 database dump and need to be sure that the data is 100% consistent and therefore it would be nice to make sure that there are no connections nor internal jobs p...
http://www.experts-exchange.com/Database/Oracle/Q_24844110.html
Is there a was to use Oracle's impdp datapump to discover what schemas are part of a dumpfile? The log that was created with the dumpfile is gone and I do not want to import the whole file.
http://www.experts-exchange.com/Database/Oracle/11.x/Q_24815454.html
Hi
I have an Oracle 10G database where we currently import data from another 10G database using the impdp facility initiated by a unix shell script. This works fine and takes about 40 minutes.
La...
http://www.experts-exchange.com/Database/Software/CRM/Oracle/Q_24097871.html
Guys- I am attempting an import while excluding several tables (Auto1, Auto2, Auto3,Auto4) however, my syntax is generating the following error in Windows...........
impdp user1/password directo...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_24626600.html
Zones:
Oracle 9.xDate Answered: 08/05/2009 Rating: 9.5 Views: 0