How do I import a dmp file into Oracle

Question

I have a  dmp file that I would like to import into Oracle 9i  How do I do that

User · Answer

Presuming you have a  dmp file created by oracle exp then  imp help y   will be your friend  It will lead you to   imp file  lt file gt  dmp show y   to see the contents of the dump and then something like  imp scott tiger example file  lt file gt  dmp fromuser  lt source gt  touser  lt dest gt    to import from one user to another  Be prepared for a long haul though if it is a complicated schema as you will need to precreate all referenced schema users  and tablespaces to make the imp work correctly

User · Answer

I am Using Oracle Database Express Edition 11g Release 2   Follow the Steps   Open run SQl Command Line  Step 1  Login as system user         SQL gt  connect system tiger   Step 2   SQL gt  CREATE USER  UserName IDENTIFIED BY Password   Step 3   SQL gt  grant dba to UserName    Step 4   SQL gt  GRANT UNLIMITED TABLESPACE TO UserName   Step 5            SQL gt  CREATE BIGFILE TABLESPACE TSD UserName              DATAFILE  tbs perm 03 dat               SIZE 8G              AUTOEXTEND ON    Open Command Prompt in Windows or Terminal in Ubuntu  Then Type   Note   if you Use Ubuntu then replace      to      in path   Step 6  C   gt  imp UserName password localhost file D  abc xyz dmp log D  abc abc 1 log full y   Done      I hope you Find Right solution here   Thanks

User · Answer

dmp files are dumps of oracle databases created with the  exp  command  You can import them using the  imp  command   If you have an oracle client intalled on your machine  you can executed the command  imp help y  to find out how it works  What will definitely help is knowing from wich schema the data was exported and what the oracle version was

User · Answer

i got solution what you are getting as per imp help y it is mentioned that imp is only valid for TRANSPORT TABLESPACE as below   Keyword  Description  Default        Keyword      Description  Default  -------------------------------------------------------------------------- USERID   username password           FULL         import entire file  N  BUFFER   size of data buffer         FROMUSER     list of owner usernames FILE     input files  EXPDAT DMP     TOUSER       list of usernames SHOW     just list file contents  N  TABLES       list of table names IGNORE   ignore create errors  N     RECORDLENGTH length of IO record GRANTS   import grants  Y            INCTYPE      incremental import type INDEXES  import indexes  Y           COMMIT       commit array insert  N  ROWS     import data rows  Y         PARFILE      parameter filename LOG      log file of screen output   CONSTRAINTS  import constraints  Y  DESTROY                overwrite tablespace data file  N  INDEXFILE              write table index info to specified file SKIP UNUSABLE INDEXES  skip maintenance of unusable indexes  N  FEEDBACK               display progress every x rows 0  TOID NOVALIDATE        skip validation of specified type ids FILESIZE               maximum size of each dump file STATISTICS             import precomputed statistics  always  RESUMABLE              suspend when a space related error is encountered N  RESUMABLE NAME         text string used to identify resumable statement RESUMABLE TIMEOUT      wait time for RESUMABLE COMPILE                compile procedures  packages  and functions  Y  STREAMS CONFIGURATION  import streams general metadata  Y  STREAMS INSTANTIATION  import streams instantiation metadata  N  DATA ONLY              import only data  N   The following keywords only apply to transportable tablespaces TRANSPORT TABLESPACE import transportable tablespace metadata  N  TABLESPACES tablespaces to be transported into database DATAFILES datafiles to be transported into database TTS OWNERS users that own data in the transportable tablespace set   So  Please create table space for your user   CREATE TABLESPACE  lt tablespace name gt  DATAFILE  lt path to save  example   C  ORACLEXE APP ORACLE ORADATA XE ABC dbf  gt  SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 10G EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M

User · Answer

imp system system-password SID file directory-you-selected FILE dmp log log-dir oracle load log fromuser infodba touser infodba commit Y

[oracle] How do I import a .dmp file into Oracle?

Examples related to oracle

Examples related to import