I'm trying to export an Oracle schema to an .sql file. It has no tables, but it has some custom types and packages.

During the steps "specify objects" and "specify data" I click "More" and select the schema to export. During the step "specify objects" I also click "Lookup" and move all objects from the left panel to the right panel. As there's no tables, I cannot do the same on the "specify data" step.

When I start exporting the tool exports the tables owned by the current user anyways. What am I doing wrong?

  • Is this the Cart feature? Jan 25, 2022 at 11:03
  • "What am I doing wrong?" >> Did you try to connect as user whose objects you're trying to export?
    – Littlefoot
    Jan 25, 2022 at 19:47

1 Answer 1


You don't have to click "More" or "Lookup". On the right side, there shows "All" by default, which means all objects will be exported. The image is illustrated as below.

enter image description here

  • That dropdown is for object types.
    – basin
    Jan 27, 2022 at 10:01
  • Have you ever tried the solution? I have tested it , the result contains only DDL as I expected.
    – Alex
    Jan 28, 2022 at 6:58
  • what did you select there?
    – basin
    Jan 28, 2022 at 10:59
  • Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.
    – Community Bot
    Jan 28, 2022 at 14:07
  • Nothing. The only things I did is to uncheck "Export Data", then I followed "Next".
    – Alex
    Feb 1, 2022 at 11:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.