Mike,

When you import a users tables into a new database, just create that
user without any tables in the new database and then run your import.
The import will have all the code to create the tables, indexes,
triggers, procedures etc...

Go back to the new database and:

Drop user user_name cascade;

Create user user_name identified by values... Etc.

Rerun your import again.

-----Original Message-----
From: Tofigh Mike (NIH/NEI) [C]
[mailto:oracledba-ezmlmshield-x43374039.[Email address protected]
Sent: Thursday, February 28, 2008 10:41 AM
To: LazyDBA Discussion
Subject: oracle 10g, disable all the trigger in a database


Dear All,

Help, I am trying to import all the users tables from one db to a new
db, but because the tables have triggers and on them, I can not import
them,

Can you please tell me how to disable all the trigger for all user at
ones

Thanks


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





******************************************************************************************
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, Alltel requests
that you immediately notify the sender and asks that you do not read the message or its
attachments, and that you delete them without copying or sending them to anyone else.



Oracle LazyDBA home page