This content has been marked as final. Show 3 replies
What user's objects are you trying to export? What user are you connected as?
Can you see the user's objects in the navigation tree? Can you export an object from the tree?
Do some other testing and provide more information about what works and what doesn't work.
I am trying to export all objects.
I am connected not as sys or sysdba, just a regular user.
Yes i can see all objects and export e.g a table form the navigation tree.
I didn't say this because i had no problems with these.
So basically everything else works its just the export doesn't.
To export a table you need to own the table or have select on the table. Also, if you do not own the table you should have select_catalog_role. If you do not have select on the table or own the table, you will not be able to the find the object using the Specify Objects step of the wizard. If you can find the object, you still may not be able to export it unless you own the object or have select_catalog_role.
On the Specify Objects panel, you must click on Lookup to get the list of objects. If you are trying to export objects in another schema, you have to click on More, select the schema and then click lookup.
Still have problems, please describe exactly what you are doing and clicking in the wizard. Indicate what privieleges you have. Also try to find the object using view-> Find DB Object and report what you did and the results.