Partitions

[gczobel]

Hi!
Two questions:
Is possible to list the add a partition branch in the Browser Folders window?

How I can identify the partitioned tables in the Table folder?

Thanks!

PL/sql dev 7.0.1.1066

 

[Marco Kalter]

No, this is not possible. You can however create a query based browser folder that includes only the partitioned tables.

 

[gczobel]

But, to make a query I need to known the table names right?
Or I can make a query to list ALL the partitioned tables?

 

[Marco Kalter]

In a User Defined Browser Folder, you can use a where clause like this:

where object_type = 'TABLE'
and (owner, object_name) in (select pt.owner, pt.table_name from all_part_tables pt)

This folder will contain all partitioned tables.