windows下Oracle命令
C:\Documents and Settings\Administrator>sqlplus /nologSQL*Plus:> Copyright (c) 1982, 2005, Oracle.All rights reserved.
SQL> conn sys/abc@orcl as sysdba
已连接。
SQL> create tablespace wenzhou2
2logging
3datafile 'C:\oracle\product\10.2.0\oradata\orcl\wenzhou2.dbf'
4 > 5autoextend on
6next 50m maxsize 5120m
7extent management local;
表空间已创建。
SQL> create user wenzhou> 2default tablespace wenzhou2;
用户已创建。
SQL> grant create user,drop user,alter user,create any view,
2drop any view,exp_full_database,imp_full_database,
3dba,connect,resource,create session to wenzhou;
授权成功。
SQL> grant unlimited tablespace to wenzhou;
授权成功。
SQL> exit
从 Oracle Database 10g Enterprise Edition> With the Partitioning, OLAP and Data Mining options 断开
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus:> 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;
页:
[1]