Oracle创建表空间、创建用户、导入/导出数据命令。

– 创建表空间，创建表空间时会占用硬盘空间
CREATE TABLESPACE NNC_DATA01 DATAFILE ‘E:\oracle\product\10.2.0\oradata\nc56\nnc_data01.dbf’ SIZE 100M AUTOEXTEND ON NEXT 20M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;
CREATE TABLESPACE NNC_DATA02 DATAFILE ‘E:\oracle\product\10.2.0\oradata\nc56\nnc_data02.dbf’ SIZE 50M AUTOEXTEND ON NEXT 10M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;
CREATE TABLESPACE NNC_DATA03 DATAFILE ‘E:\oracle\product\10.2.0\oradata\nc56\nnc_data03.dbf’ SIZE 50M AUTOEXTEND ON NEXT 10M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K ;

CREATE TABLESPACE NNC_INDEX01 DATAFILE ‘E:\oracle\product\10.2.0\oradata\nc56\nnc_index01.dbf’ SIZE 50M AUTOEXTEND ON NEXT 10M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;
CREATE TABLESPACE NNC_INDEX02 DATAFILE ‘E:\oracle\product\10.2.0\oradata\nc56\nnc_index02.dbf’ SIZE 50M AUTOEXTEND ON NEXT 10M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;
CREATE TABLESPACE NNC_INDEX03 DATAFILE ‘E:\oracle\product\10.2.0\oradata\nc56\nnc_index03.dbf’ SIZE 50M AUTOEXTEND ON NEXT 10M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;

– 创建Oracle用户
CREATE USER nc56 IDENTIFIED BY nc56 DEFAULT TABLESPACE NNC_DATA01 TEMPORARY TABLESPACE temp;

– 赋dba权限给用户nc56
GRANT connect,dba to nc56;

– 导入数据命令，导入Oracle数据到相应的用户下
导入命令：imp nc56/nc56@orcl file=d:\hrtsx.dmp log=hrtsx.log buffer=496000 full=y ignore=y commit=y

– 导出数据命令，导出Oracle用户下的数据到指定目录
导出命令：exp hrtsx/hrtsx@orcl file=hrtsx.dmp log=hrtsx.log owner=hrtsx buffer=496000