Cannot import--URGENT

From: Ravindra B <ravindra_at_navin.com>
Date: Sat, 11 May 2002 17:23:19 -0800
Message-ID: <F001.0045EE6A.20020511172319@fatcity.com>

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

--

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

Author: Ravindra B
  INET: ravindra_at_navin.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). Received on Sat May 11 2002 - 20:23:19 CDT