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
0
votes
1 answer

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

SQL Server data pump, migrating many db's into one

So I have a scenario where i have 7+ databases witch I intend to migrate into one database. At one point the plan is to have those 7+ databases handling the metadata but all the sales data will be driven in the new single database. So I need to keep…
sushibite
  • 1
0
votes
1 answer

How to import table in different number of columns?

I'm using data pump export/import method in Oracle 11GR2 So, I have table A containing (ID, Name, Address, City, Phone) and I want to export it into table B (ID, Name, Address). How can I import data from table A to table B that have different…
Cemox
  • 43
  • 8
0
votes
1 answer

Oracle Import dump files to another user(schema)

I am very new to DBA works. I have already exported (expdp) table and saved the dump files in a directory. I don't know the password of SCOTT user (default & example user). I want to import my tables to scott, but how can I? I am able to import…
Ayam
  • 43
  • 7
0
votes
1 answer

is it possible to export 10g database schema from 11g server

I want to export 10g database schema and import the files into 11g database. Here are my constraints: I have little space in 10g database server to export the dump file for schemas. I tried to export using 11g client installed on my Windows 7…
user3171342
  • 51
  • 2
  • 10
0
votes
1 answer

Getting the following error ORA-27038 when importing dump file

I imported dump file using data pump to another DB_B on the same server. The server already contains the same DB_A which has similar contents as the dump file. I did the following command (below) with DB_A and it works perfectly but when I used it…
dimas
  • 2,487
  • 6
  • 40
  • 66
0
votes
1 answer

Oracle Data Pump - from local machine importing to remote server

I am connected to remote Oracle server from my local machine & dropped all the table in one of the db schema. Now I need to import a dmp file located in the same remote machine from my machine. How can I achieve that? Note - RDC to the server its…
Arav
  • 163
  • 1
  • 1
  • 10
0
votes
0 answers

Magmi multi site import with Datapump API - different prices on same SKU-s

The structure of project is 2 websites with same categories and same products. The only difference is the price (basicly the second shop is something like wholesale). So we have: website A - language 1 & language 2 website B - language 1 & language…
nordashi
  • 76
  • 7
0
votes
0 answers

oracle data pump import to another schema ora-31696

When trying to export import into a table into another schema i am facing the following issue: ORA-31696: unable to export/import TABLE_DATA:"schemaowner"."tablename":"SYS_P41" using client specified AUTOMATIC method ORA-31696: unable to…
George Georgiou
  • 455
  • 2
  • 14
  • 27
0
votes
0 answers

oracle data pump export file keeps growing in size

I am using oracle data pump in a similar way: USERNAME=myname PASSWORD=pass INSTANCE=dbinstance QUERY='employees:"WHERE hire_date > TO_TIMESTAMP('0101','YYMM')"' PATH=/tmp/test expdp $USERNAME/$PASSWORD@$INSTANCE directory=EXPORT_DIR…
George Georgiou
  • 455
  • 2
  • 14
  • 27
0
votes
1 answer

Oracle data pump using java

I'am trying to use Oracle data pump using java. How can I export data from Oracle using java and retrieve a dump file of the same.
Vivian Ambrose
  • 3
  • 4
0
votes
0 answers

Why tables are not created at destination database when using DMBS_STREAMS_ADM.MAINATIAN_TABLES procedure?

I am implementing an Oracle Streams environment that replicates DML changes on some tables. I used the procedure DBMS_STREAMS_ADM.MAINTAIN_TABLES with the instantiation as DBMS_STREAMS_ADM.INSTANTIATION_TABLE_NETWORK, all the blocks of the procedure…
Moustafa
  • 11
  • 4
0
votes
0 answers

In Oracle Datapump, can Network_Link be used to point to the same server?

I've seen lots of examples using network_link to remote servers, getting rid of the middle man create dump, import dump. I need to do this on the same server. I have a production database. I have a test database. They are both on the same RAC, same…
johnny
  • 19,272
  • 52
  • 157
  • 259
0
votes
1 answer

Oracle datapump import into new 10.2.0.5 database

We are currently migrating to a brand new server/Oracle DB in order to upgrade our memory (RAM). In order to populate this database we have decided to use the Oracle Data Pump functionality and creating the flat export file completed without…
pwlm
  • 174
  • 2
  • 2
  • 19
0
votes
2 answers

How to access the database imported through datapump

I just imported data dump through below command: IMPDP user/pass FULL=Y DUMPFILE=BIRDV24012014.DMP LOGFILE=BIRDV24012014.log; The dump has been restored the issue is i dont know how to connect to this database that i just imported, what service or…
Maven
  • 14,587
  • 42
  • 113
  • 174
1 2 3
…
13 14