按照下面一步一步就可直接完成
cmd进入windows命令行窗口
sqlplus / as sysdba
进入SQL操作
–创建表空间(SQL中操作) 红色是自己命名的表空间
CREATE TABLESPACE ITIM DATAFILE ‘ITIM.DBF’ SIZE 100M autoextend on next 20M maxsize 20480M;
–创建用户 itime_yf_new账户密码
create user itime_yf_new identified by itime_yf_new default tablespace ITIM temporary tablespace TEMP profile DEFAULT;
–分配权限 itime_yf_new 账户密码
grant connect to itime_yf_new with admin option;
grant dba to itime_yf_new with admin option;
grant unlimited tablespace to itime_yf_new with admin option;
exit;退出SQL操作
–导入数据库(windows的cmd中操作或者linux中直接操作)
imp itime_yf_new/itime_yf_new@ORCL file=’D:\3qidatabase\itime4_release.dmp’ full=Y;
–级联删除表空间(sqlplus / as sysdba 下操作的)
drop tablespace ITIM including contents and datafiles cascade constraints;
–级联删除用户
drop user itime_yf_new cascade;
用sqlplus / as sysdba登录时，不能修改system、sys用户的密码 用sqlplus /nolog后再conn / as sysdba登录时，可以修改system、sys用户的密码