Database Administration (MOSC)

MOSC Banner

Finding tablespace with unlimited maxsize

edited Sep 17, 2009 5:15AM in Database Administration (MOSC) 15 commentsAnswered ✓
Hi !

 

I need to find, through sceduled pl/sql job, the autoextend tablespaces for wich maxsize is unlimited.

Now we're using a SELECT in wich WHERE clause has hard-coded the maxsize, like this :
 

SELECT s1.tablespace_name
            FROM ( SELECT tablespace_name, SUM (maxbytes) AS maxbytes
                     FROM dba_data_files
                  GROUP BY tablespace_name) s1
           WHERE s1.maxbytes >= 34359721984;

I think it's not very "transportable". Is there's another way to make it cleaner ?

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