Re: o9i (9.2) Full export nor exporting some users/schemas

On 30 Jun 2004 10:02:47 -0700, sminni_SPAM_DIVERTER_at_planage.com (Sanjay Minni) wrote:

>Hi
>
>Using Oracle 9i (9.2) on w2k
>We are getting a very peculiar behaviour
>On doing a full export from DOS command prompt
>using exp & logged in as system
>
>tables of a few schemas/users are not getting
>exported at all
>
>Further we are not able to login as those users
>We tried resetting the password of those users
>by logging in as system but no luck though we can
>see the data
>
>Thanks for your help
>Regards
>Sanjay Minni

What does your exp command line look like? If you are referencing an export parm file, what does it look like?

What does SELECT * FROM DBA_USERS show about your problem users? Received on Wed Jun 30 2004 - 14:15:56 CDT