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/[email protected] ignore=y full=y file=G:\study\oracle\pms(1).dmp

imp etlkr/[email protected] file=D:\GTS_TRX_VOUCHER_DTAL.dmp full=y