importing dump file into schema/user without including triggers, sequences
Posted on 2009-04-03
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.