Sorry! There was mistake in first replay. Here it comes better one:
----

My experiences are not like that. I have one big schema with some thousand DB objects.
Almost all tables have constraints (primary keys, foreign keys, uniqueness...) indexes, most of them
have triggers, some of them affect other tables. A cloned this schema countless times. There was no
problem with tables. True is that some views (etc.) are not created in first pass. For that reason
and for speed reason I do it in such a way:

exp user/[Email Address Removed] file=dmt owner=user consistent=yes rows=yes

imp user/[Email Address Removed] file=dmt owner=user fromuser=user touser=user rows=yes ignore=no constraints=no indexes=no grants=no
imp user/[Email Address Removed] file=dmt owner=user fromuser=user touser=user rows=no ignore=yes constraints=no indexes=yes grants=no
imp user/[Email Address Removed] file=dmt owner=user fromuser=user touser=user rows=no ignore=yes constraints=yes indexes=no grants=no
imp user/[Email Address Removed] file=dmt owner=user fromuser=user touser=user rows=no ignore=yes constraints=no indexes=no grants=yes

100 % OK.

KAzi

Tofigh Mike (NIH/NEI) [C] wrote:
> I did create the users and tables spaces,
> but these the tables have triggers and foreign keys, and foreign keys
> on tables depend on each other.
>
> Thanks
>
> -----Original Message-----
> From: Tom
> [mailto:oracledba-ezmlmshield-x48522008.[Email address protected]
> Sent: Thursday, February 28, 2008 10:51 AM
> To: LazyDBA Discussion
> Subject: RE: oracle 10g, disable all the trigger in a database
>
> 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.
>
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>


Oracle LazyDBA home page