03_oracle 10g表空间创建步骤

SELECT * FROM DBA_TABLESPACES;

–ORACLE10G表空间创建步骤
CREATE TABLESPACE ETLKR DATAFILE ‘D:\oracle\oradata\orcl\ETLKR.DBF’ SIZE 5G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

ALTER DATABASE DATAFILE ‘D:\oracle\oradata\orcl\ETLKR.DBF’ AUTOEXTEND ON;

drop user kr;
CREATE USER etlkr identified by etlkr default tablespace ETLKR TEMPORARY TABLESPACE TEMP;

grant connect ,resource to etlkr;
grant dba to etlkr;

imp pms/pms123@PMS ignore=y full=y file=G:\study\oracle\pms(1).dmp
imp etlkr/etlkr@orcl file=D:\GTS_TRX_VOUCHER_DTAL.dmp full=y