importing dump file into schema/user without including triggers, sequences

Hi,

I am using following import command

imp user_name_xyz/password full=y file=abc_data_dump_file.dmp ignore=y

to load the dump file data, structure etc everything into the  user/schema 'user_name_xyz'.
Is there is a way, option to exclude triggers, sequences  through import command, while importing the dump file into the schema. Any sample code, ideas, resources, links highly appreciated. Thanks in advance.
LVL 7
gudii9Asked:
Who is Participating?
 
fsze88Connect With a Mentor Commented:
try to create a file named imp_exclude.par or imp_include.par and content is as
imp_exclude.par
EXCLUDE=FUNCTION
EXCLUDE=PROCEDURE
EXCLUDE=PACKAGE

imp_include.par
INCLUDE=FUNCTION
INCLUDE=PROCEDURE
INCLUDE=PACKAGE
........
and run

impdp user_name_xyz/password DUMPFILE=abc_data_dump_file.dmp PARFILE=imp_include.par

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_import.htm#i1007865
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_import.htm#i1007761
0
 
FayyazConnect With a Mentor Commented:
use datapump expdp/impdp instead of traditional exp/imp utilities as mentioned above
0
 
gudii9Author Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.