Describe table wont show partitions for partitioned tables since upgrading Oracle from 12.1 to 12.2. I tried a few, same problem.
Oracle 12.2
Toad 13.1.1.5
I have a cloned version of this database where the partitions will display, the only difference between the databases is compatibility is set to 12.2 on the clone, its set to 12.1 on the one where its not showing. I cant change that though, I guess its a bug, is it known about and is there a workaround?
Is there any error? Turn on spool SQL to capture the SQL that Toad runs when you go to the partitions tab.
Main menu -> Database -> Spool SQL.
Post the SQL and any errors here.
no errors, can see the SQL spooling
select partitioning_type, subpartitioning_type
, interval
, interval_subpartition, autolist, autolist_subpartition
, ref_ptn_constraint_name
from sys.DBA_PART_TABLES
where owner = :own
and table_name = :Tablename
and then the binds for those which when I apply to the query return the data as Id expect
issue repeats on other PC
Well then it sounds like an Oracle problem. Try running that SQL in the editor using either the correct bind values or swapping them out for literals.
that was my point I did and data returns, SQL developer displays the partitions ok
Can you post the result of the query? If you don't want to show it here, export it to excel and email it to me. john.dorlon@quest.com
sure, will mail now
John,
Was this ever solved?
Sorry, I just realized the original post was about partitions not showing in the partition tab. But my issue is partitions not showing in the table script (Script tab).
I'm seeing this with two tables that I partitioned, and am creating new partitions via split partition. Only the original partition, that was created along with the table, is showing in toad. But dba_tab_partitions shows all of the partitions, using the query obtained via Spool SQL.
P_NULL is the original partition, P_202412 was created via split partition.
This is in 25.2.83, BTW.
Yep! It was set to default/max. I looked around (obviously too quickly) in there but didn't see that option.
That did it! Thanks, John!
I hope you had a great Christmas.
But why didn't that affect any other range partitioned tables? This is the first time I've seen partitions missing from a script.
Not sure. Can you give me an example of a table that doesn't work for?
