Oracle 导入另外user 的table

本实验是关于data 的exp 一个用户scott 下面imp到另外一个用户中。---------
在instance = sheng 的导出scott.emp[Oracle@aoracle ~]$ exp scott/oracle tables=emp file="/u01/rman/file01.txt";Export: Release 10.2.0.1.0 - Production on Fri Dec 16 09:56:22 2011Copyright （c） 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set （possible charset conversion）About to export specified tables via Conventional Path ...
. . exporting table                            EMP         14 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.下面imp到另外一个用户的table 中。下面建立另外一个user：
SQL> select name from v$tablespace;NAME
------------------------------
SYSTEM
UNDOTBS2
SYSAUX
USERS
TEMPSQL> create tablespace TB_DBS datafile "/u02/sheng/tbsdbs01.dbf" size 20m;Tablespace created.SQL> select name from v$tablespace;NAME
------------------------------
SYSTEM
UNDOTBS2
SYSAUX
USERS
TEMP
TB_DBS6 rows selected.SQL> create user dbs identified by dbs default tablespace tb_dbs;User created.SQL> select username,account_status from dba_users where username like "DBS%";USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
DBSNMP                         OPEN
DBS                            OPEN下面连一下：
SQL> CONN DBS/DBS
ERROR:
ORA-01045: user DBS lacks CREATE SESSION privilege; logon denied
Warning: You are no longer connected to ORACLE.SQL> grant create session ，resource to dbs;Grant succeeded.SQL> conn dbs/dbs
Connected.
SQL> select * from tab;no rows selectedSQL> 好，下面把scott 用户下的emp table imp 到dbs 用户下：[oracle@aoracle ~]$ imp system/manager file="/u01/rman/file01.txt" fromuser=scott touser=dbs;Import: Release 10.2.0.1.0 - Production on Fri Dec 16 10:54:29 2011Copyright （c） 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining optionsExport file created by EXPORT:V10.02.01 via conventional pathWarning: the objects were exported by SCOTT, not by youimport done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set （possible charset conversion）
. importing SCOTT"s objects into DBS
. . importing table                          "EMP"         14 rows imported
IMP-00017: following statement failed with ORACLE error 942:
"ALTER TABLE "EMP" ADD CONSTRAINT "FK_DEPTNO" FOREIGN KEY （"DEPTNO"） REFEREN"
"CES "DEPT" （"DEPTNO"） ENABLE NOVALIDATE"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
About to enable constraints...
IMP-00017: following statement failed with ORACLE error 2430:
"ALTER TABLE "EMP" ENABLE CONSTRAINT "FK_DEPTNO""
Import terminated successfully with warnings.SQL> select count（*） from emp; COUNT（*）
----------
        14SQL> show user;
USER is "DBS"
SQL> ORA-01152错误解决方法用老的备份controlfileora-600 [2662] && ora-01031 权限不足的解决（ora-01152）相关资讯 Oracle基础教程

Oracle块编程返回结果集详解（11/10/2013 10:45:58）
Oracle基础教程之设置系统全局区（08/22/2013 14:24:00）
Oracle基础教程知识点总结（06/18/2013 07:43:32）

Oracle基础教程之tkprof程序详解（10/22/2013 11:49:50）
Oracle基础教程之sqlplus汉字乱码（07/18/2013 16:30:00）
Oracle 管理之 Linux 网络基础（02/16/2013 18:37:35）

本文评论查看全部评论（0）