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

Reply via email to