sqldeveloper export tool ignores filter by schema



  • 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?



  • 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




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2