How was the export created? Do you have the output from the export, or the script that created it?
-Joe --- 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: Joe Raube 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).
