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

Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0406301630.62dbfabd_at_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 Received on Thu Jul 01 2004 - 23:45:04 CDT