Importing Oracle dump on windows machine

1. sqlplus /nolog
2. connect sys/abcdef as sysdba
3. Create tablespace VINPRO datafile 'C:\Oracle\DB_11g\oradata\orcl11g\VINPRO_DATA.dbf ' size 100m autoextend on extent management local;
4. create user vinoracle identified by hijkl default tablespace VINPRO;
5.
GRANT CONNECT TO vinoracle;
GRANT DBA TO vinoracle;
GRANT DELETE_CATALOG_ROLE TO vinoracle;
GRANT EXECUTE_CATALOG_ROLE TO vinoracle;
GRANT EXP_FULL_DATABASE TO vinoracle;
GRANT IMP_FULL_DATABASE To vinoracle;
GRANT RESOURCE TO vinoracle;
GRANT RECOVERY_CATALOG_OWNER TO vinoracle;
GRANT SCHEDULER_ADMIN TO vinoracle;
GRANT ALTER ANY INDEX TO vinoracle;
GRANT ALTER ANY MATERIALIZED VIEW TO vinoracle;
GRANT ALTER ANY PROCEDURE TO vinoracle;
GRANT ALTER ANY SEQUENCE TO vinoracle;
GRANT ALTER ANY TABLE TO vinoracle;
GRANT ALTER ANY TRIGGER TO vinoracle;
GRANT ALTER ANY TYPE TO vinoracle;
GRANT ALTER SESSION TO vinoracle;
GRANT ANALYZE ANY DICTIONARY TO vinoracle;
GRANT BACKUP ANY TABLE TO vinoracle;
GRANT COMMENT ANY TABLE TO vinoracle;
GRANT CREATE ANY DIRECTORY TO vinoracle;
GRANT CREATE ANY INDEX TO vinoracle;
GRANT CREATE ANY MATERIALIZED VIEW TO vinoracle;
GRANT CREATE ANY PROCEDURE TO vinoracle;
GRANT CREATE ANY SEQUENCE TO vinoracle;
GRANT CREATE ANY TABLE TO vinoracle;
GRANT CREATE ANY TRIGGER TO vinoracle;
GRANT CREATE ANY TYPE TO vinoracle;
GRANT CREATE ANY VIEW TO vinoracle;
GRANT CREATE DATABASE LINK TO vinoracle;
GRANT CREATE MATERIALIZED VIEW TO vinoracle;
GRANT CREATE PROCEDURE TO vinoracle;
GRANT CREATE PUBLIC DATABASE LINK TO vinoracle;
GRANT CREATE SEQUENCE TO vinoracle;
GRANT CREATE TABLE TO vinoracle;
GRANT CREATE TRIGGER TO vinoracle;
GRANT CREATE VIEW TO vinoracle;
GRANT DEBUG ANY PROCEDURE TO vinoracle;
GRANT DELETE ANY TABLE TO vinoracle;
GRANT DROP ANY TABLE TO vinoracle;
GRANT DROP PUBLIC DATABASE LINK TO vinoracle;
GRANT EXECUTE ANY PROCEDURE TO vinoracle;
GRANT EXECUTE ANY PROGRAM TO vinoracle;
GRANT EXECUTE ANY TYPE TO vinoracle;
GRANT EXPORT FULL DATABASE TO vinoracle;
GRANT GRANT ANY PRIVILEGE TO vinoracle;
GRANT IMPORT FULL DATABASE TO vinoracle;
GRANT INSERT ANY TABLE TO vinoracle;
GRANT LOCK ANY TABLE TO vinoracle;
GRANT MANAGE SCHEDULER TO vinoracle;
GRANT SELECT ANY DICTIONARY TO vinoracle;
GRANT SELECT ANY SEQUENCE TO vinoracle;
GRANT SELECT ANY TABLE TO vinoracle;
GRANT SELECT ANY TRANSACTION TO vinoracle;
GRANT UNDER ANY TABLE TO vinoracle;
GRANT UNLIMITED TABLESPACE TO vinoracle;
GRANT UPDATE ANY TABLE TO vinoracle;

7. exit
8. imp vinoracle/hijkl file='C:\Oracle\DB_11g\Dumps\VR.dmp' log='C:\Oracle\DB_11g\logs\VR.log' buffer=1048576 full=y

Share on Facebook Share on Twitter Share on Google Plus

About Unknown

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.