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;