oracle的导入导出

Microsoft Windows [版本 6.1.7601] 
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。 

C:\Users\Administrator>sqlplus / as sysdba 

SQL*Plus: Release 11.2.0.1.0 Production on 星期四 3月 29 15:54:55 2012 

Copyright (c) 1982, 2010, Oracle.  All rights reserved. 

ERROR: 
ORA-01031: insufficient privileges 


请输入用户名:  sys 
输入口令: 
ERROR: 
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER 


请输入用户名:  sys / as sysdba 
输入口令: 

连接到: 
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options 

SQL> select userenv('language') from dual; 

USERENV('LANGUAGE') 
---------------------------------------------------- 
SIMPLIFIED CHINESE_CHINA.ZHS16GBK 

SQL> exit 
从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断 
开 

C:\Users\Administrator>sqlplus / as sysdba 

SQL*Plus: Release 11.2.0.1.0 Production on 星期四 3月 29 15:56:35 2012 

Copyright (c) 1982, 2010, Oracle.  All rights reserved. 

ERROR: 
ORA-01031: insufficient privileges 


请输入用户名:  sys / as sysdba 
输入口令: 

连接到: 
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options 

SQL> select distinct tablespace_name from dba_data_files; 

TABLESPACE_NAME 
------------------------------ 
UNDOTBS1 
SYSAUX 
USERS 
SYSTEM 
EXAMPLE 

SQL> select file_name from dba_data_files; 

FILE_NAME 
-------------------------------------------------------------------------------- 

D:\ORACLE11G\ORADATA\ORCL\USERS01.DBF 
D:\ORACLE11G\ORADATA\ORCL\UNDOTBS01.DBF 
D:\ORACLE11G\ORADATA\ORCL\SYSAUX01.DBF 
D:\ORACLE11G\ORADATA\ORCL\SYSTEM01.DBF 
D:\ORACLE11G\ORADATA\ORCL\EXAMPLE01.DBF 

SQL> create tablespace cs datafile 'D:\ORACLE11G\ORADATA\ORCL\cs01.dbf' 
  2  size 1g autoextend on next 1m maxsize unlimited; 

表空间已创建。 

SQL> create user olsuser identified by olsuser default tablespace cs; 

用户已创建。 

SQL> grant dba to olsuser; 

授权成功。 

SQL> exit 
从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production 
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断 
开 

C:\Users\Administrator>imp olsuser/olsuser fromuser=olsuser touser=olsuser file= 
d:\olsuser0329.dmp 

Import: Release 11.2.0.1.0 - Production on 星期四 3月 29 15:58:42 2012 

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. 


连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Produc 
tion 
With the Partitioning, OLAP, Data Mining and Real Application Testing options 

经由常规路径由 EXPORT:V10.02.01 创建的导出文件 
已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入 
. . 正在导入表                       "ACCOUNT"