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

On 30 Jun 2004 10:02:47 -0700, sminni_SPAM_DIVERTER@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?

On 30 Jun 2004 10:02:47 -0700, sminni_SPAM_DIVERTER@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


Please do not multi-post. Most people here monitor all Oracle
newsgroup, so you both won't get more responses, and you have the
possibility someone is going to waste free time, if the message has
been already responded to in a different newsgroup.
Also, don't try to put riddles ('some' users didn't export)


--
Sybrand Bakker, Senior Oracle DBA

sminni_SPAM_DIVERTER@planage.com (Sanjay Minni) wrote in message news:<4fe109d.0406300902.73c38766@posting.google.c om>...
> 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

Sanjay,
Do the ID's in question have create session privilege?
What Oracle error is returned when you try to log on to these sessions?
What are the ID's in question?
What type of objects fail to export (dba_objects.object_type)
Are you sure the export file is complete and can be read all the way to the end?

The answers to these questions might help someone identify what is wrong.
HTH -- Mark D Powell --

"Sanjay Minni" <sminni_SPAM_DIVERTER@planage.com> wrote in message
news:4fe109d.0406300902.73c38766@posting.google.co m...
> 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
>
Are you sure you are not looking at synonyms?

Paul

Sybrand Bakker <sybrandb@hccnet.nl> wrote in message news:<v0c6e0pqn46phkum7jm2h8vtovvl2i2bdk@4ax.com>. ..
>
> Please do not multi-post. Most people here monitor all Oracle
> newsgroup, so you both won't get more responses, and you have the
> possibility someone is going to waste free time, if the message has
> been already responded to in a different newsgroup.
> Also, don't try to put riddles ('some' users didn't export)

I have posted only once (using google) to
comp.databases.oracle.server
Pl let me know where saw the multi-posting

Mark.Powell@eds.com (Mark D Powell) wrote in message news:<2687bb95.0406301630.62dbfabd@posting.google. com>...
> Do the ID's in question have create session privilege?
> What Oracle error is returned when you try to log on to these sessions?
> What are the ID's in question?
> What type of objects fail to export (dba_objects.object_type)
> Are you sure the export file is complete and can be read all the way to the end?
>
> The answers to these questions might help someone identify what is wrong.
> HTH -- Mark D Powell --

Thanks all for your assistance
We were using the DOS Command line export
>exp
It appears it was connecting to the wrong database
(the OMS repository instead of the actual database)
This was overcome by using
>exp user@<actualDatabaseInstance>

But this brings to another issue - licencing.
We have oracle 9i licence Standard Edition (not Enterprise Edition)
1. Can we install OMS and use the Enterprise Console
2. What are the GUI management utilities available in standard edition
3. We have several small < 5 user standalone sites in standard edition.
OMS is an overkill. I find GUI tools functioning are
limited without OMS. Broadly what tools can be used specially
if we want to administer thru a dial up connection also

Regards
Sanjay Minni

sminni_SPAM_DIVERTER@planage.com (Sanjay Minni) wrote in message news:<4fe109d.0407012045.4b29038c@posting.google.c om>...
> Mark.Powell@eds.com (Mark D Powell) wrote in message news:<2687bb95.0406301630.62dbfabd@posting.google. com>...
> > Do the ID's in question have create session privilege?
> > What Oracle error is returned when you try to log on to these sessions?
> > What are the ID's in question?
> > What type of objects fail to export (dba_objects.object_type)
> > Are you sure the export file is complete and can be read all the way to the end?
> >
> > The answers to these questions might help someone identify what is wrong.
> > HTH -- Mark D Powell --
>
> Thanks all for your assistance
> We were using the DOS Command line export
> >exp
> It appears it was connecting to the wrong database
> (the OMS repository instead of the actual database)
> This was overcome by using
> >exp user@<actualDatabaseInstance>
>
> But this brings to another issue - licencing.
> We have oracle 9i licence Standard Edition (not Enterprise Edition)
> 1. Can we install OMS and use the Enterprise Console
> 2. What are the GUI management utilities available in standard edition
> 3. We have several small < 5 user standalone sites in standard edition.
> OMS is an overkill. I find GUI tools functioning are
> limited without OMS. Broadly what tools can be used specially
> if we want to administer thru a dial up connection also
>
> Regards
> Sanjay Minni

There are many 3rd party tools available that can be used to manage
the db and whose licensing fees are well below's Oracle's for OEM
(with any of the optional packages)

See www.maxdbt.com for trial copy. CA also had db management product.
Then there is TOAD, paid and free versions, etc....

That request should be a new thread. You can probably find posts on
this topic in the archives.

HTH -- Mark D Powell --