Re: imp table by table

And if the table already exists, look to disable the constraint, and then enable them after the import.

Raj

                                                                                                                    
                    "Yechiel                                                                                        
                    Adar"                To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>        
                    <adar76_at_inter        cc:                                                                        
                    .net.il>             Subject:     Re: imp table by table                                        
                    Sent by:                                                                                        
                    root_at_fatcity.                                                                                   
                    com                                                                                             
                                                                                                                    
                                                                                                                    
                    December 10,                                                                                    
                    2002 01:35 PM                                                                                   
                    Please                                                                                          
                    respond to                                                                                      
                    ORACLE-L                                                                                        
                                                                                                                    
                                                                                                                    

Maybe you can do this:

1. imp index=n constraint=n
2. imp ignore=y rows=no

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, December 10, 2002 11:58 AM

> Hi all,
>
> I have dump files (1 table 1 dump file, dump filename is tablename)
>
> How to create imp scripts that will import all those dump files without
any referential problem
>
> Something like this:
>
>
> select 'imp system/manager file=./' || object_name || '.dmp || '
fromuser=myuser touser=myuser'
> from user_objects
> where object_name = myuser
> order by creation;
>
>
> do you think this will work ?
>
> My problem is with referential
>
>
> Thanks
>
> Mery X'Mas

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Rajesh.Rao_at_jpmchase.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).