This discussion is archived
2 Replies Latest reply: Oct 25, 2012 2:27 PM by trent RSS

Export not obeying filter

trent Expert
Currently Being Moderated
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 ACE Moderator
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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.