Stack Overflow
Stack Overflow

Questions tagged [oracle-dump]

Oracle dump file (. DMP) is binary storage used by Oracle users and database administrators to backup data.

53 questions
81
votes
3 answers

How to import an Oracle database from dmp file and log file?

How would I go about creating a database from a dump file? I do not have an existing database with the same structure on my system so it has to be complete with jobs, events, tables, and so on. I placed the dump and log file in E: drive I have tried…
praveenb
  • 10,549
  • 14
  • 61
  • 83
42
votes
9 answers

How to determine the Schemas inside an Oracle Data Pump Export file

I have an Oracle database backup file (.dmp) that was created with expdp. The .dmp file was an export of an entire database. I need to restore 1 of the schemas from within this dump file. I don't know the names of the schemas inside this dump…
KyleLanser
  • 2,699
  • 2
  • 21
  • 21
39
votes
10 answers

Howto import an oracle dump in an different tablespace

I want to import an oracle dump into a different tablespace. I have a tablespace A used by User A. I've revoked DBA on this user and given him the grants connect and resource. Then I've dumped everything with the command exp a/*** owner=a…
Michiel Overeem
  • 3,894
  • 2
  • 27
  • 39
7
votes
1 answer

invalid value for parameter, 'directory'

I am trying to import a datadump using impdp utility and who command is as follows: IMPDP project/project DIRECTORY=e:\_workline\workspace\rfc_16012014\project_staging DUMPFILE=project_staging.dmp LOGFILE=project_staging_log.log; But I get this…
Maven
  • 14,587
  • 42
  • 113
  • 174
6
votes
3 answers

How to export users in Oracle with its roles and system privileges using expdp?

I am trying to export a schema/user in Oracle with its roles and system privileges. I don't want to export any data or any table. I have tried to export users using the following command. expdp system/system@gisdblocal include=user DIRECTORY =…
Ayaz49
  • 325
  • 2
  • 4
  • 18
6
votes
2 answers

Is it possible to do oracle import util as non-dba user?

When I try to import an oracle dump. Following the error displayed, Export file created by EXPORT:V10.02.01 via direct path IMP-00013: only a DBA can import a file exported by another DBA IMP-00000: Import terminated unsuccessfully I just wondering…
nayakam
  • 4,149
  • 7
  • 42
  • 62
4
votes
1 answer

Oracle import dump file throwing ORA-39088 error

I am trying to import data from a dump file created by Oracle 10g data pump utility. The command that I am issuing is impdp \"username/password@DB as sysdba\" remap_schema=SRC_SCHEMA:TARGET_SCHEMA…
user170008
  • 1,046
  • 6
  • 17
  • 31
4
votes
2 answers

Importing oracle10g data dmp file into oracle 11g

I am trying to import a dump file generated using oracle 10g, here is the export log that I got: Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining, and Real…
rajat
  • 3,415
  • 15
  • 56
  • 90
4
votes
2 answers

Does Expdp utility requires EXP_FULL_DATABASE privilege while exporting the same schema over network link

I am using expdp utility over a network link. I need to export only one schema which I own. ideally, it should allow me to export the schema which I own. But I am getting error like ORA-31631: privileges are required ORA-39149: cannot link…
somaniA
  • 614
  • 2
  • 7
  • 30
4
votes
3 answers

Restoring RMAN Oracle 10g Backup in Oracle 11g

I have the RMAN full database backup of oracle 10g (10.2.0.3) on Sun Solaris OS which I want to restore on oracle 11g (11.2.0.3) on Linux OS. The backup pieces were transferred to the oracle 11g server manually in binary mode. The Oracle 11g is…
Harsh
  • 49
  • 1
  • 5
3
votes
5 answers

IMP-00010 not a valid export file, header failed verification in Oracle Import

I have export DMP files which are exported using the exp command from oracle version 11.2.0.4.0. I want to import the file in my oracle version 11.2.0.2.0. But during import I am getting an error as 'IMP-00010 not a valid export file, header failed…
Andrew
  • 3,632
  • 24
  • 64
  • 113
3
votes
1 answer

IMPDP remap_schema multiple files

Here is the correct syntax for a single schema IMPDP rename : impdp system/**** directory=DATA_PUMP_DIR dumpfile=export_something.dmp logfile=imp.log remap_schema=name:newname How would you import multiple schemas from one export while remapping…
A_V
  • 362
  • 1
  • 3
  • 19
3
votes
1 answer

Cannot import Oracle dump: IMP-00033: Warning: Table not found in export file

I have an Oracle dump (.dmp) that I want to import into my local Oracle instance. But when I do a full import, it fails with IMP-00033: Warning: Table not found in export file. Some facts: using imp system/pass ignore=yes…
Bozho
  • 588,226
  • 146
  • 1,060
  • 1,140
3
votes
4 answers

how to import oracle 11g dump file to 10g oracle

when I tried to import oracle database 11g into oracle 10g I got this error. IMP:00010 Not a valid export file. header failed identification IMP:00000 Import terminated unsucessfully any help, please
ezzaam
  • 61
  • 1
  • 1
  • 7
3
votes
2 answers

importing a dump file into oracle 11gr2 get errors

While importing a dump file into oracle 11gr2 I am getting this error please suggest a way to resolve this *Warning: the objects were exported by D7IDMP, not by you import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export…
Maddy
  • 3,726
  • 9
  • 41
  • 55
1
2 3 4