Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01918: user 'APDBA' does not exist

user1165357Nov 22 2011 — edited Nov 23 2011
Hello I have the following statement
CREATE OR REPLACE FUNCTION APDBA.MUNIN_TBS_PCTUSED1
(
  tablespace IN VARCHAR2 
) RETURN NUMBER AS
A NUMBER;
 
BEGIN 
  SELECT round(100*(sum(bytes)/1024/1024)/(sum(maxbytes)/1024/1024),1) INTO A
  FROM dba_data_files
  WHERE tablespace_name = tablespace;
   
  RETURN A;
END MUNIN_TBS_PCTUSED1;
/
The problem is that the user APDBA exists in the database and i am receiving the error ORA-01918: user 'APDBA' does not exist

thanks a lot
This post has been answered by Peter Gjelstrup on Nov 23 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 21 2011
Added on Nov 22 2011
10 comments
6,051 views