Oracle创建表空间和用户并授予权限

1.创建表空间：cmd-->sqlplus sys/ABCabc123 as sysdba;-->
     -->CREATE TABLESPACE HNUFJCS DATAFILE 'D:/app/chris/product/11.2.0/dbhome_1/oradata/sample/HNUFJCS.dbf' SIZE 500M UNIFORM SIZE 128k;
2.创建用户：create user fjcstest identified by fjcstest default tablespace HNUFJCS  temporary tablespace TEMP;
3.赋予权限：grant connect,dba,resource to fjcstest;
4.导表，imp命令：使用quit退出SQL-->imp fjcstest/fjcstest@ORCL file=D:20180629shujuku+xuesheng+peiti.dmp full=y ignore=y
5.导入.sql文件：用txt打开-->PLSQLDeveloper中以fjcstest/fjcstest登录-->在命令窗口中执行.sql文件中的