在CMD中启动sqlplus

言归正转，下面具体说一下如何启动。

1. 设置正确的ORACLE实例

2. 启动SQLPLUS

3. 连接

4. 启动/关闭数据库

相应的在DOS命令下执行:

1. set ORACLE_SID = $INSTANCE_NAME

2. sqlplus /nolog

3. connect user/password as sysdba

4. startup/shutdown

执行如下：

C:\>set ORACLE_SID = test

C:\>sqlplus /nolog

SQL*Plus: Release 9.0.1.0.1 - Production on 星期三 1月 12 19:42:08 2005

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SQL> connect system/manager as sysdba

已连接到空闲例程。

SQL> startup

ORACLE 例程已经启动。

Total System Global Area 118255568 bytes

Fixed Size 282576 bytes

Variable Size 83886080 bytes

Database Buffers 33554432 bytes

Redo Buffers 532480 bytes

数据库装载完毕。

数据库已经打开。

SQL>

在CMD下进入sqlplus，使用中的简单样例。

eg001

CREATE TABLE "SYSTEM"."XS4"
( "A" CHAR(8),
"B" NUMBER(2),
"C" DATE,
"D" CHAR(8),
"E" CHAR(8),
CONSTRAINT "PK_A" PRIMARY KEY ("A") VALIDATE ,
CONSTRAINT "CH_B" CHECK (b between 1 and 8) VALIDATE )
TABLESPACE "TEST01"

eg002

create table xs5
( xh char(6) not null,
kch char(6) not null,
cj number(2) null,
xf number(2) null,
constraint "pk_xs5" primary key (xh,kch) validate )
tablespace test01

eg003

create table system.xs4
( kch char(8) not null,
kcm char(8) not null,
kkxq number(1) not null,
d char(8) not null,
e char(8) not null,
constraint ch_kkxq check(kkxq between 1 and 8),
constraint "pk_kch" primary key(kch))
pctfree 10 pctused 40 initrans 1 maxtrans 255
tablespace test01
storage(initial 64k minextents 1 pctincrease 40
freelists 1 freelist groups 1 )

eg004

CREATE SMALLFILE TABLESPACE "INDX"
DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\sjwj_indx'
SIZE 50M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO /*创建表空间INDX */

eg005

insert into system.xs3(a,b,c) values('11111','22222','4444444') /*向表中插入数据*/