oracle 建立表空间和用户

 1.建立表空间，

create tablespace "NETHRA" DATAFILE 'D:\DataBase\Oracle\iClass\iclass\iclass.DBF' SIZE 100M
AUTOEXTEND   ON   NEXT  10M


2.创建用户并授权
CREATE USER "NETHRA" PROFILE "DEFAULT" IDENTIFIED BY "nethra" DEFAULT TABLESPACE "NETHRA" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK
GRANT "CONNECT" TO "NETHRA"
GRANT "DBA" TO "NETHRA


3.
exp nethra/nethra@iclass file=d:\iclass20160108.dmp full=y

4.
imp nethra/nethra@iclass file=d:\iclass20160108.dmp full=y