Ravi,
Why is your fromuser=sys? Are you specifying a parfile
anywhere?
Jack
- Ravindra B <ravindra_at_navin.com> 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: jack_silvey_at_yahoo.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 - 21:08:19 CDT
