1、不会,但如果以存在相同表,在imp时后面加ignore=true
2、EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR)
3、create user user_name identified by password default tablespace ... temporary tablespace ...;
完整的语法:
CREATE USER user IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS 'CN=user'}
[ DEFAULT TABLESPACE tablespace
| TEMPORARY TABLESPACE tablespace
| QUOTA { integer [K | M] | UNLIMITED } ON tablespace
[ QUOTA { integer [K | M] | UNLIMITED } ON tablespace ] ...
| PROFILE profile
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK } ... ]
2、EXP SCOTT/TIGER GRANTS=Y TABLES=(EMP,DEPT,MGR)
3、create user user_name identified by password default tablespace ... temporary tablespace ...;
完整的语法:
CREATE USER user IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS 'CN=user'}
[ DEFAULT TABLESPACE tablespace
| TEMPORARY TABLESPACE tablespace
| QUOTA { integer [K | M] | UNLIMITED } ON tablespace
[ QUOTA { integer [K | M] | UNLIMITED } ON tablespace ] ...
| PROFILE profile
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK } ... ]
2.如何来指定导出特定的表。如: D_T开头的表
3.如何创建一个用户名?1.不会,需要加参数ignore=Y,忽略建表错误
2.加参数tables=,需要注意full这个参数不能和tables一起共用
3. CREATE USER user IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS 'CN=user'}
[ DEFAULT TABLESPACE tablespace
| TEMPORARY TABLESPACE tablespace
| QUOTA { integer [K | M] | UNLIMITED } ON tablespace
[ QUOTA { integer [K | M] | UNLIMITED } ON tablespace ] ...
| PROFILE profile
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK } ... ]