Notice: Undefined index: HTTP_ACCEPT_ENCODING in C:\server\web\www.showyounger.com\s-system.php on line 2
Oracle创建用户导入数据库 | 小样儿(ShowYounger)
小样儿,顶呱呱!!![http://www.showyounger.com]
- 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