window oracle 命令,windows下Oracle命令

C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 8月 27 10:32:34 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys/abc@orcl as sysdba

已连接。

SQL> create tablespace wenzhou2

2  logging

3  datafile 'C:\oracle\product\10.2.0\oradata\orcl\wenzhou2.dbf'

4  size 300m

5  autoextend on

6  next 50m maxsize 5120m

7  extent management local;

表空间已创建。

SQL> create user wenzhou identified by wenzhou

2  default tablespace wenzhou2;

用户已创建。

SQL> grant create user,drop user,alter user,create any view,

2  drop any view,exp_full_database,imp_full_database,

3  dba,connect,resource,create session to wenzhou;

授权成功。

SQL> grant unlimited tablespace to wenzhou;

授权成功。

SQL> exit

从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options 断开

C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 8月 27 10:52:38 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn wenzhou_user/wenzhou_user@orcl

已连接。

imp wenzhou/wenzhou@orcl fromuser=wlw_user touser=wenzhou file=C:\wenzhou\wlw_user_20121015.dmp log=C:\back\wzdaorulog.txt

删除表空间

drop tablespace abc including contents and datafiles;