Re: Trouble with imp on 8.1.6

exp system/pass_at_service file=file.dmp log=exp.log user=(adtlite)

The exp.log shows all objects exported correctly.

imp system/pass_at_service file=file.dmp log=test.log fromuser=system touser=caler tables=(*)

Rick

                                                                                       
                            
                    orantdba                                                           
                            
                    <orantdba_at_net        To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    scape.net>           cc:                                           
                            
                    Sent by:             Subject:     Re: Trouble with imp on 8.1.6    
                            
                    root_at_fatcity.                                                      
                            
                    com                                                                
                            
                                                                                       
                            
                                                                                       
                            
                    01/18/2002                                                         
                            
                    11:50 AM                                                           
                            
                    Please                                                             
                            
                    respond to                                                         
                            
                    ORACLE-L                                                           
                            
                                                                                       
                            
                                                                                       
                            

HI Rick,

Could you share with us the export statement and the import statement you used.
 Tha will help figure out what went wrong.

John

Rick_Cale_at_teamhealth.com wrote:

>Hi All,
>
>I did a successfull export on 8.1.6 for user=....
>I am trying to import on same server into another user. I get following
>message but no tables are created?
>I have full privs.
>
>Can someone help?
>
>Connected to: Oracle8i Release 8.1.6.0.0 - Production
>JServer Release 8.1.6.0.0 - Production
>
>Export file created by EXPORT:V08.01.06 via conventional path
>import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set
>import server uses US7ASCII character set (possible charset conversion)
>Import terminated successfully without warnings.
>
>Thanks
>Rick
>
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: orantdba
  INET: orantdba_at_netscape.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).




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

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).