Database Administration (MOSC)

MOSC Banner

ora 1561 when dropping tablespace

edited Dec 5, 2008 7:09AM in Database Administration (MOSC) 3 commentsAnswered
Drop tablespace users including contents;

give me ora-1561 error.

This tablespace has no objects.

select

total.file_name fname,

total.bytes/1024 totsiz,

nvl(sum(free.bytes)/1024,0) avasiz,

(1-nvl(sum(free.bytes),0)/total.bytes)*100 pctusd

total.file_name fname, total.bytes/1024 totsiz, nvl(sum(free.bytes)/1024,0) avasiz, (1-nvl(sum(free.bytes),0)/total.bytes)*100 pctusd

.file_name fname, total.bytes/1024 totsiz, nvl(sum(free.bytes)/1024,0) avasiz, (1-nvl(sum(free.bytes),0)/total.bytes)*100 pctusd

.bytes/1024 totsiz, nvl(sum(free.bytes)/1024,0) avasiz, (1-nvl(sum(free.bytes),0)/total.bytes)*100 pctusd

nvl(sum(free.bytes)/1024,0) avasiz, (1-nvl(sum(free.bytes),0)/total.bytes)*100 pctusd (1-nvl(sum(free

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