如何将.dmp文件导入Oracle?

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

我有一个.dmp文件，我想将它导入Oracle 9i。我该怎么做呢?

6 个解决方案

#1

Presuming you have a .dmp file created by oracle exp then

假设您有一个.dmp文件，由oracle exp创建

imp help=y

will be your friend. It will lead you to

将你的朋友。它会引导你

imp file=<file>.dmp show=y

to see the contents of the dump and then something like

查看转储的内容，然后类似的操作

imp scott/tiger@example file=<file>.dmp fromuser=<source> touser=<dest>

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

从一个用户导入另一个用户。如果它是一个复杂的模式，您需要预先创建所有引用的模式用户和表空间，从而使imp正常工作，那么您需要为长期的工作做好准备

#2

I am Using Oracle Database Express Edition 11g Release 2.

我正在使用Oracle数据库Express Edition 11g版本2。

Follow the Steps:

遵循的步骤:

Open run SQl Command Line

Open run SQl命令行。

Step 1: Login as system user

第一步:作为系统用户登录

       SQL> connect system/tiger

Step 2 : SQL> CREATE USER UserName IDENTIFIED BY Password;

步骤2:SQL>通过密码创建用户名;

Step 3 : SQL> grant dba to UserName ;

步骤3:SQL>授予dba用户名;

Step 4 : SQL> GRANT UNLIMITED TABLESPACE TO UserName;

步骤4:SQL>向用户名授予无限制的表空间;

Step 5:

步骤5:

        SQL> 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:

在Ubuntu的Windows或终端中打开命令提示符。然后输入:

Note : if you Use Ubuntu then replace " \" to " /" in path.

注意:如果你使用Ubuntu，那么在路径中替换“\”到“/”。

Step 6: C:\> imp UserName/password@localhost file=D:\abc\xyz.dmp log=D:\abc\abc_1.log full=y;

步骤6:C:\> imp用户名/password@localhost文件=D:\abc\xyz。dmp日志= D:\ abc \ abc_1。日志已满= y;

Done....

完成....

I hope you Find Right solution here.

我希望你能找到正确的解决方法。

Thanks.

谢谢。

#3

Here you can find some tips on how to use the imp command.

在这里，您可以找到一些关于如何使用imp命令的技巧。

#4

imp system/system-password@SID file=directory-you-selected\FILE.dmp log=log-dir\oracle_load.log fromuser=infodba touser=infodba commit=Y

#5

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:

我得到了一个解决方案，你得到的每一个imp帮助=y，上面提到imp只对传输表空间有效，如下所示:

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 <tablespace name> DATAFILE <path to save, example: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\ABC.dbf'> SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 10G EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

#6

-1

.dmp files are dumps of oracle databases created with the "exp" command. You can import them using the "imp" command.

.dmp文件是使用“exp”命令创建的oracle数据库的转储。您可以使用“imp”命令导入它们。

If you have an oracle client intalled on your machine, you can executed the command

如果您的机器上集成了oracle客户端，您可以执行该命令

imp help=y

小鬼帮助= 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.

看看它是如何工作的。从wich模式了解数据被导出以及oracle版本是什么，肯定会有所帮助。

#1