Re: Q: Export without any Table Data...why?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 12 May 2005 08:10:46 -0700
Message-ID: <1115910646.790909.275820@o13g2000cwo.googlegroups.com>

Ralf Bender wrote:
> Hello,
>
> something strange happens here and I don't know why:
>
> I want to export a Oracle 8.1 Database as I do often from another pc
in
> the network.
> Starting the export with user SYSTEM, Oracle starts to export all,
but
> without any Tabledata?
> What's going wrong here? User SYSTEM got the role EXP_FULL_DATABASE.
>
> This is my export command:
> exp userid=system/manager_at_database full=y compress=n log=exp.log
> file=full.dmp
>
> thanks
> ralf

Have you actually verified this information after doing the full import *without* rows=n switch?
Have you tried adding rows=y switch in both exp/imp commands? Although it's set to y by default but no harm if you do specify it.

Regards
/Rauf Received on Thu May 12 2005 - 10:10:46 CDT