oracle数据库密码:orcl
创建账号:CREATE USER vdrs IDENTIFIED BY manager DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
授权:grant connect,resource,dba to vdrs
CREATE SMALLFILE TABLESPACE vdrs DATAFILE 'F:\ORADATA\ORCL\vdsr.DBF'
SIZE 100M
AUTOEXTEND ON NEXT 100M
MAXSIZE UNLIMITED
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO vdrs
命令提示符窗口下执行:imp vdrs/manager@orcl full=y file=d:\vdrs.dmp ignore=y log=e:\log.txt
创建账号:CREATE USER vdrs IDENTIFIED BY manager DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;
授权:grant connect,resource,dba to vdrs
CREATE SMALLFILE TABLESPACE vdrs DATAFILE 'F:\ORADATA\ORCL\vdsr.DBF'
SIZE 100M
AUTOEXTEND ON NEXT 100M
MAXSIZE UNLIMITED
LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO vdrs
命令提示符窗口下执行:imp vdrs/manager@orcl full=y file=d:\vdrs.dmp ignore=y log=e:\log.txt