oracle部分总结
//创建表空间
create tablespace DATATEST datafile 'D:\SERVER\DATABASE\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\DATATEST.dbf' size 100M
autoextend ON next 10M maxsize 200M;
create user testserver_user identified by testserver_user
default tablespace test_data
temporary tablespace test_temp;
//给用户授予权限
grant connect,resource to testserver_user;
//导入dmp
imp 用户名/密码@数据库sid file=路径 full=y
//查询用户所有的表
select count(1) from user_tables;
