Stack Overflow
Stack Overflow

Questions tagged [datapump]

A server based bulk import and export facility in Oracle

Data Pump Export and Import replace Import and Export. It can be used to import or export tables, schemas or entire databases in a dump file.

Questions tagged should also be tagged .

Further reading:

201 questions
-1
votes
1 answer

Create a Data Pump (Export/Import) History Table Oracle

Can you create a table in Oracle database which stores all the details about the data pump operations or keeps a history of all data pump transactions.
Nibin George
  • 57
  • 1
  • 8
-1
votes
1 answer

Oracle 10g data import

I am have a server which has oracle 10g installed. I have created dump of all the databases. I want to import those dumps into newly installed machine on which 10g is also installed. When I try to import dump it is giving error like below…
Dushyant Gohil
  • 67
  • 1
  • 12
-1
votes
2 answers

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…
Shravan
  • 223
  • 1
  • 5
  • 12
-1
votes
2 answers

shell script to ask username and path store files

i need a shell script to ask the username and pathe to store the expdp file in a specified path. please help me. below is my script. #!/bin/sh STARTTIME=`date` export ORACLE_SID=test export ORACLE_HOME=`cat /etc/oratab|grep ^${ORACLE_SID}:|cut…
user3422419
  • 21
  • 1
  • 10
-3
votes
1 answer

. . skipping table while import in 9i

When iam trying to import exp dump into 9i database its giving imp ****/****@**** FULL=Y IGNORE=Y FILE=exp_****_4.dmp LOG=imp_****_4.log export client uses WE8ISO8859P1 character set (possible charset conversion) . importing SYSTEM's objects into…
Whiterabbit
  • 1
  • 2
1 2 3
…
13
14