C:\Documents and Settings\Administrator>sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 5月 6 11:03:42 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
请输入用户名: system/systme
ERROR:
ORA-01017: invalid username/password; logon denied
请输入用户名:
C:\Documents and Settings\Administrator>sqlplus sys/sys
SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 5月 6 11:04:00 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
请输入用户名:
C:\Documents and Settings\Administrator>sqlplus sys/sys as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 5月 6 11:04:11 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> create tableplace skwl_data datafile 'skwl_data.ora' size 100m autoextend
2 ;
create tableplace skwl_data datafile 'skwl_data.ora' size 100m autoextend
*
第 1 行出现错误:
ORA-00901: 无效 CREATE 命令
SQL> create tablespace skwl_data datafile 'skwl_data.ora' size 100m autoextend;
create tablespace skwl_data datafile 'skwl_data.ora' size 100m autoextend
*
第 1 行出现错误:
ORA-02491: AUTOEXTEND 子句中缺少要求的关键字 ON 或 OFF
SQL> create tablespace skwl_data datafile 'skwl_data.ora' size 100m autoextend;
create tablespace skwl_data datafile 'skwl_data.ora' size 100m autoextend
*
第 1 行出现错误:
ORA-02491: AUTOEXTEND 子句中缺少要求的关键字 ON 或 OFF
SQL> create tablespace skwl_data datafile 'skwl_data.ora' size 100m autoextend on;
表空间已创建。
SQL> create user culture defalt tablespace skwl_data;
create user culture defalt tablespace skwl_data
*
第 1 行出现错误:
ORA-00922: 选项缺失或无效
SQL> create user culture default tablespace skwl_data;
create user culture default tablespace skwl_data
*
第 1 行出现错误:
ORA-01938: 必须为 CREATE USER 指定 IDENTIFIED BY
SQL> create user culture identified by 'culture' default tablespace skwl_data;
create user culture identified by 'culture' default tablespace skwl_data
*
第 1 行出现错误:
ORA-00988: 口令缺失或无效
SQL> create user culture identified by culture default tablespace skwl_data;
用户已创建。
SQL>