520240linger 发表于 2013-1-26 14:20:03

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>
 
 
 
页: [1]
查看完整版本: oracle操作doc命令