How was the export created?
Do you have the output from the export, or the script that created
it?
-Joe
- 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: Joe Raube
INET: jraube_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:38:19 CDT