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"
版权所有 (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"