sqlplus
sys as sysdba
CREATE TABLESPACE ymc
DATAFILE 'G:\app\Administrator\oradata\ymc.DBF'
SIZE 50M
AUTOEXTEND ON
AUTOALLOCATE ;
CREATE USER ymc
IDENTIFIED BY "123"
DEFAULT TABLESPACE ymc
QUOTA UNLIMITED ON ymc;
GRANT CREATE TABLE TO ymc;
GRANT CREATE TRIGGER TO ymc;
GRANT CREATE SEQUENCE TO ymc;
GRANT CREATE VIEW TO ymc;
GRANT CREATE PROCEDURE TO ymc;
GRANT CONNECT TO ymc;
GRANT DBA TO ymc;
imp ymc/123@orcl file=d:\data\ym3jj_20140311.dmp full=y
