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
0 answers

DataPump Export ORA-00922: missing or invalid option

Oracle Database 11g Enterprise Edition 11.2.0.1.0 64bit Production DataPump Export command: EXPDP.EXE SCHEMA1/SCHEMA1PASS@ORCL DIRECTORY=exp_dir1 DUMPFILE=SCHEMA1.dmp LOGFILE=SCHEMA1.LOG EXCLUDE=GRANT FULL=N REUSE_DUMPFILES=Y…
Lior I
  • 47
  • 1
  • 8
0
votes
1 answer

AWS RDS datapump directory to be used

I know nothing much about aws. Could you help to resolve the issue. I need to take a dump of my Database in AWS Oracle RDS, so trying a command which is shown below expdp ***/****@WINDMIG5 schemas=agTransform directory=/rdsdbdata/datapump…
XSL Query
  • 11
  • 4
0
votes
1 answer

Oracle Data Pump (Exclude and Metadata)

I need to perform a datapump in 11.2 and want to exclude some tables but include the metadata only.. i.e. export a schema, but exclude about 12 tables (which is easy enough), but then I need to just export metadata from about 20 tables. Is this…
user2496011
  • 67
  • 3
  • 12
0
votes
1 answer

Oracle Datapump: Invalid operation at line 6224

I've a Oracle dump file that I'm trying to import to AWS RDS Oracle 12.1.0.2.v17 database. The dump file looks like this: $ strings EXPDP.dmp | head -n…
kontrollanten
  • 2,649
  • 19
  • 32
0
votes
0 answers

Trying to import Datapump dump into remote Oracle Server via SQL

I am trying to import a datapump dump file into a remote server via SQLPlus. So, local machine -> remote oracle Server Dump file is on local machine on a SMB share. I have written a little script for that operation, however it fails with errors. The…
user3829915
  • 45
  • 5
0
votes
2 answers

Unable to drop existing master table in sql developer

I was using yeasterday many times Data Pump in Sql Developer Wizard to export and import data. After each export/import a new master table appeared under the "+" button in sql developer(view->dba). I wanted to drop all this tables(about 10 tables)…
drk
  • 1
  • 2
0
votes
0 answers

Oracle DB Developer error on importing .dmp

Trying to open a .dmp I've been sent. I get the following errors from the Import Wizard on Oracle SQL Developer. Any thoughts on what my problem might be? I have set full file/folder permissions on Linux and otherwise think I'm using standard…
Mark_Anderson
  • 1,229
  • 1
  • 12
  • 34
0
votes
1 answer

How to export full schema without any constraint issues for one month date range

I need to export the full schema of a one month data range. I have a lot of partitioned tables inside the schema, so I need a query to export a schema without any constraint issue or partitioned table issue. Usually I use to take separate table…
Geethanjali Ramaraj
  • 1
  • 3
0
votes
1 answer

"How to recover a schema dropped after EXPDP without doing the impdp?

I was playing - for my upcoming project- how to perform expdp and impdp on play environment which is two levels away from the test environment . So i did expdp with scott/tiger and exported the scott schema. However, out of curiosity, I dropped…
Gurbaa Magaala
  • 21
  • 1
  • 5
0
votes
1 answer

IMPDP uses more disk space than expected

Background: I've been tasked with importing a large amount of data from a production database to a test database (Oracle 12c release 2 running on RHEL) and I'm using Data Pump. The first time I imported the tables, The tables were created and the…
Taylor Iserman
  • 175
  • 1
  • 16
0
votes
1 answer

Schema export using oracle datapump

What are the objects will be exported while taking a full schema export using oracle datapump utility?
Joshua
  • 1
  • 1
0
votes
1 answer

expdp issue ORA-39001: invalid argument value

Originally, the script was like: C:\Windows\system32>expdp anna/12356@inst2 PARFILE=E:\expdp\db001\_db001.par Export: Release 11.2.0.3.0 - Production on Mon Sep 3 22:59:30 2018 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights…
Lydia_5678
  • 1
  • 1
  • 1
0
votes
1 answer

Oracle External Table

Not sure if this is the right place for this question but as I could not found the answer on Oracle or through Google. Can I back up my table (say table A) data from Oracle using external table, and is the right way to do it? The data will be older…
ashim
  • 67
  • 1
  • 2
  • 12
0
votes
1 answer

How To Confirm IMPDP is success or not in oracle

i imported full database from 10g to 11g using DATAPUMP, But below is the final message which i got. Job "SYS"."SYS_IMPORT_FULL_01" completed with 5345 error(s) at 20:03:01 how can i confirm it's success or not ?? how to know the source database…
Sha
  • 13
  • 7
0
votes
1 answer

Oracle Data Pump Transfer Between Databases

I have a specific need for data pump and I am having a hard time searching for a solution. Currently, I have a exp/imp program that exports tables (selectively based on queries) from one database, and imports that same data into another database.…
Gary G
  • 41
  • 2
1 2 3
…
13 14