Help on Import

Hi,

[Quoted] I need to import a database from a different Sun box running Oracle 8.1.5 and Solaris 7.0 to another Sun box running Oracle 8.1.7 and Solaris 8.0. I created a database using a script and then performed the import using a dump [Quoted] file (provided to me, supposedly a full export dump) as follow:

%> imp file=20010425.dmp show=y full=y

The log shows a statement "Import terminated successfully without warnings." [Quoted] However, when I tried to login to the database using the Enterprise Manager [Quoted] tool, there seemed to have no tables created. When executing the command from Server Manager

    svrmgr> select * from tab;

only system tables are shown.

What went wrong? Did I missed out any step? Any help is appreciated. Thanks.

Regards,
Vonnie Received on Sun Apr 29 2001 - 09:50:00 CEST