Ravi, Why is your fromuser=sys? Are you specifying a parfile anywhere?
Jack --- Ravindra B <[EMAIL PROTECTED]> wrote: > I am trying to import from my production database to > another database.Table level export > was done on the production databse for 4 table.It > ended w/o any errors. > > When I am trying to import to anther user on a > different datasbe the import compltes > successfully without any warning but no > table/records are imported > The tables being imported are not existing in the > new user's schema. > I have tried this on 8.1.7 to 8.1.7 and also on > 8.1.7 to 9.0.1. > > These tables on the production database are > protected so I can export them > only as sys user.I am attaching the log from the > import.What is the problem. > Am i missing anything > > imp sys/change_on_install fromuser=sys touser=ravi > file=g.dmp log=g.log > > Connected to: Oracle9i Enterprise Edition Release > 9.0.1.1.1 - Production > With the Partitioning option > JServer Release 9.0.1.1.1 - Production > > Export file created by EXPORT:V08.01.07 via > conventional path > import done in WE8MSWIN1252 character set and > AL16UTF16 NCHAR character set > export client uses WE8ISO8859P1 character set > (possible charset conversion) > export server uses US7ASCII NCHAR character set > (possible ncharset conversion) > Import terminated successfully without warnings. > > Ravindra > __________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
