(no subject)

From: Tiger Woods <arhk_at_yahoo.com>
Date: Thu, 28 Dec 2000 21:18:29 -0800 (PST)
Message-Id: <10725.125460@fatcity.com>

here is my problem:
I have created a procedure which return error: SQL> begin
  2 howmuchspace;
  3 end;
  4 /
begin
*
ERROR at line 1:

ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_SPACE", line 40
ORA-06512: at "OPS$ORACLE.HOWMUCHSPACE", line 17
ORA-06512: at line 2

however when i run the pl/sql code of procedure like this:
"declare
cursor seg_info_cur is
select owner, segment_name, segment_type from naughty_segments;
total_blocks number;
total_bytes number;
used_blocks number;
used_bytes number;
unused_blocks number;
unused_bytes number;

last_ext_full number;
last_ext_blank number;
last_used_block number;

begin
for v_seg_info_cur in seg_info_cur
loop
DBMS_SPACE.UNUSED_SPACE(v_seg_info_cur.owner, v_seg_info_cur.segment_name, v_seg_
info_cur.SEGMENT_TYPE, total_blocks,
total_bytes,unused_blocks, unused_bytes, las t_ext_full, last_ext_blank, last_used_block); dbms_output.put_line(v_seg_info_cur.owner||'.'|| v_seg_info_cur.segment_name||'.'

|| v_seg_info_cur.SEGMENT_TYPE);
used_blocks := (total_blocks-unused_blocks);
used_bytes := (total_bytes-unused_bytes);
dbms_output.put_line('total_blocks:

'||total_blocks);

dbms_output.put_line('total_bytes [KB]:
'||round(total_bytes/1024,0));

dbms_output.put_line('used_blocks:
'||used_blocks);

dbms_output.put_line('used_bytes [KB]:
'||round(used_bytes/1024,0));

dbms_output.put_line('unused_blocks:
'||unused_blocks);

dbms_output.put_line('unused_bytes [KB]:

'||round(unused_bytes/1024,0));

dbms_output.put_line('last_ext_full:
'||last_ext_full);

dbms_output.put_line('last_ext_blank:
'||last_ext_blank);

dbms_output.put_line('last_used_block:
'||last_used_block);

end loop;
end;
I don't understand why. can you help me out. regards,

Asim Riaz Kaghzi
Oracle DBA,
Stamford, CT 06092
Res: 203.357.0255
Off: 203.316.6792

Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/

From: Hannah.M.Doran_at_sb.com
Date: Fri, 29 Dec 2000 12:43:13 -0500
Subject: OT: RE: how to create new user for the newly created databse.

I dont mind these *stupid* questions as you say. You don't always know what is happening with the person posing the question. Perhaps they were thrown into the job due to someone leaving and do not even know where to start. Maybe the manuals aren't there....

Ok, granted, I'd know enough to go to the Oracle site and download the docs, or look at the FAQ or even buy a book. But you never know. Maybe the poster wouldn't even mind a response that just TELLS them where to look.

If you dont want to answer the question, then dont. But I wouldn't want to discourage people from posting to this fabulous list. Especially newbies!

Scott.Shafer_at_dcpds.cpms.osd.mil on 12/29/2000 12:16:46 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: RE: how to create new user for the newly created databse.

OR...
Follow the link at the bottom of each email to http://www.orafaq.com and look in the faq. There's a lot of info there.

--Scott

> -----Original Message-----
> From:   Joseph S. Testa [SMTP:teci_at_oracle-dba.com]
> Sent:   Friday, December 29, 2000 10:36 AM
> To:     Multiple recipients of list ORACLE-L
> Subject:     Re: how to create new user for the newly created databse.
>
> point well taken, hence my original answer to the question was:
>
> you want to use the create user command, break out the docs and look it
> up.
>
> Kinda like the fish concept, give a man a fish, he'll be back to have
> him give you more, teach him to fish and he becomes

Received on Thu Dec 28 2000 - 23:18:29 CST