- sqlplus system/password@orcl
- SQL> create user testdb identified by testdb888 default tablespace users temporary tablespace temp;
- 用户已创建
- SQL> grant connect,resource,dba to testdb;
- 授权成功。
- SQL> revoke dba from testdb;
- SQL> drop user testdb;
- SQL> drop user testdb cascade;
- imp testdb/testdb@orcl
- 导入文件: EXPDAT.DMP> E:\db\testdb001.dmp
- 由于对象已存在, 忽略创建错误 (yes/no): no > yes
- 导入整个导出文件 (yes/no): no >
- 用户名: testdb