Database DataWarehousing (MOSC)

MOSC Banner

Partition Check

edited Dec 19, 2019 3:55AM in Database DataWarehousing (MOSC) 7 commentsAnswered ✓

Hi All,

Oracle 11gR2.

There are few partitioned tables in a database. Partitioned by range on date & time. Created daily.

How to check through sql query;

1.List of partitioned tables and their size

2. List of all tables along with partition tables and size

3. size of each partition,

4. size of partition for a range of years (say 2001 to 2008)

Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center