oracle中doc操作,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

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>