oracle操作doc下令

oracle操作doc命令

C:\Documents and Settings\Administrator>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 5月 6 11:03:42 2011

请输入用户名: 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

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

连接到:
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 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>

oracle操作doc下令

相关推荐