Oracle常用命令操作

1.管理员登陆：sqlplus / as sysdba
2.用户创建：create user ams identified by ams;
3.用户删除：drop user ams cascade;
4.授予用户权限：grant connect, resource, dba to ams;
5.用户切换：connect username/password
6.创建表空间:
create tablespace ams
logging 
datafile 'd:\oracle\product\10.2.0\oradata\ams.dbf' 
size 32m 
autoextend on 
next 32m maxsize 2048m 
extent management local;

7.修改用户表空间
alter user ams default tablespace ams;
8.删除表空间
drop tablespace mytbs01 including contents ;
以下两条命令在cmd下直接运行

9.数据导入：imp ams/ams@localhost:1521/orcl file=d:\abcde\AMS-2013-04-27.dmp full=y
10.数据导出：exp ams/ams@localhost:1521/orcl file=d:\abcde\daochu.dmp owner=(ams)