记录常用的oracle数据库操作命令:
2.创建表空间:create tablespace oa datafile 'D:\oracle\oradata\orcl\oa.dbf' size 200M autoextend on next 50m maxsize 20480m extent management local;
3.创建用户:create user oa identified by oa default tablespace oa;
4.用户授权:grant connect,dba to oa;
5.导入数据库:imp oa/oa@orcl file=e:\oa.dmp full=y;
8.删除表空间oa:DROP TABLESPACE oa INCLUDING CONTENTS AND DATAFILES;