Importing Oracle Database using imp utility

1)optional but recommended: open SQL Developer and create a new Table space for the new(import) schema from the SYS User (SYSDBA Role)

CREATE TABLESPACE PTS_DW_TS
DATAFILE '/u01/app/oracle/oradata/orcl12c/orcl/pts_dw_ts.dbf' 
SIZE 100M AUTOEXTEND ON  MAXSIZE unlimited;

2) create a new User similar to the User for which the Database export has been created

create user PTS_DW identified by Admin123 
default tablespace PTS_DW_TS quota unlimited on PTS_DW_TS;

3) grant privileges to the new User

grant connect, create session, imp_full_database to PTS_DW ;

image

4) open a terminal and navigate to the imp utility directory and invoke the utility

cd /u01/app/oracle/product/12.1.0.2/db_1/bin
imp PTS_DW/Admin123@orcl 
file=/media/sf_vboxEx/exp_OrdMgmt.dmp 
log=PTS_DW_OBIAimp.log full=y;

image

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.