Re: Help on Import

"Vonnie" <vonnie_at_lauclan.com> wrote in message news:9cggf8$802$1_at_newsie.singa.pore.net...
> Hi,
>
> 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
> 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."
> However, when I tried to login to the database using the Enterprise
 Manager
> 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
>
>

Try to answer for yourself what the function of show=y does. Show=Y means you want to show only what the import is going to do.

Regards,

Sybrand Bakker, Oracle DBA Received on Sun Apr 29 2001 - 10:10:15 CEST