Re: Trouble with imp on 8.1.6

Hi Rick,

Try

imp system/pass_at_service file=file.dmp log=test.log fromuser=adtlitetouser=caler  John

Rick_Cale_at_teamhealth.com wrote:

  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=systemtouser=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 statementyou used. Tha will help figure out what went wrong.JohnRick_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 followingmessage but no tables are created?I have full privs.Can someone help?Connected to: Oracle8i Release 8.1.6.0.0 - ProductionJServer Release 8.1.6.0.0 - ProductionExport file created by EXPORT:V08.01.06 via conventional pathimport done in WE8ISO8859P1 character set and US7ASCII NCHAR character setimport server uses US7ASCII character set (possible charset conversion)Import terminated successfully without warnings.ThanksRick     

    --Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: orantdba  INET: orantdba@netscape.netFat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051San Diego, California        -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from).  You mayalso send the HELP command for other information (like subscribing).