| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546 |
- 查看所有表（plsql此用户登录后）//查此用户下
- select table_name from user_tables;
- //统计所有表
- select count(table_name) from user_tables;
- --删除表空间
- DROP TABLESPACE bjhts INCLUDING CONTENTS AND DATAFILES;
- DROP TABLESPACE bjhts_temp INCLUDING CONTENTS AND DATAFILES;
- --删除用户
- drop user bjhts cascade
- --创建表空间
- create temporary tablespace bjhts_temp
- tempfile 'D:\oracle\tablespace\bjhts_temp.dbf'
- size 1024m
- autoextend on
- next 1024m maxsize 2048m
- extent management local;
- create tablespace bjhts
- logging
- datafile 'D:\oracle\tablespace\bjhts.dbf'
- size 1024m
- autoextend on
- next 1024m maxsize 10240m
- extent management local;
- --创建用户（用户在表空间下）
- create user bjhts identified by bjhts
- default tablespace bjhts
- temporary tablespace bjhts_temp;
- grant connect,resource,dba to bjhts;
- --执行命令导入dmp
- imp userid=用户名/密码@orcl file=d:\xxx.dmp full=y
|
