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