2 Replies Latest reply: Oct 25, 2012 4:27 PM by trent RSS

    Export not obeying filter

    trent
      I found it hard to pick the exact pattern... But it seems like if you select one object type to export, it will export only that object of the object type you select, but export all objects in the type you havent selected to export.
      create table table1(
      test1 varchar2(20));
      /
      create table table3(
      test1 varchar2(20));
      /
      create table table2(
      test1 varchar2(20));/
      
      create or replace package p1
      as
        l_t varchar2(20);
        l_s varchar2(30);
      end p1;  
      /
      create or replace package p2
      as
        l_t varchar2(20);
        l_s varchar2(30);
      end p2;
      /
      create or replace package p3
      as
        l_t varchar2(20);
        l_s varchar2(30);
      end p3;
      /
      
      create or replace type t1 as table of varchar2(20);
      /
      create or replace type t2 as table of varchar2(20);
      /
      create or replace type t3 as table of varchar2(20);
      /
      (just to create a few objects.. if i only created tables, it the bug didnt happen)

      Tools --> Database Export...

      Save as --> Worksheet

      Add BYTE is the only option selected

      Select only one object. E.g. P1, to export.

      next --> next --> finish

      FIlter has not strictly been obeyed.

      ...

      OK just to test further, I created the objects in 11.2.

      Selected only t1 to be exported, It seems like the behaviour when selected only one object is to export that object of that object type, and export everything else that is a different type.

      Hope that makes sense!?
      About
      -----

      Oracle SQL Developer 3.2.10.09
      Version 3.2.10.09
      Build MAIN-09.57
      Copyright © 2005, 2012 Oracle. All Rights Reserved.
      IDE Version: 11.1.1.4.37.59.48
      Product ID: oracle.sqldeveloper
      Product Version: 11.2.0.09.57>

      Windows 7 64bit.
        • 1. Re: Export not obeying filter
          Jeff Smith Sqldev Pm-Oracle
          Did you select ONLY tables in the object type selector page?

          The filter doesn't explicitly limit what's exported - it only filters objects selected of that specific type. So if you leave everything selected on the types page, then in your filter add a single table, it will only export that table, but will then grab all packages, sequences, etc.

          If you only want tables, uncheck everything but tables, then use the filter to specify the exact tables you want.
          • 2. Re: Export not obeying filter
            trent
            Oh righto, that makes sense. I always thought the object selector was a pre-filter for the object you want displayed in the next page, and that you'd still have to specifically add them to be exported.

            Cheers for the info.