Recompile invalid objects failed

[Ablakios]

Hi,
I was trying to recompile invalid objects and got the following error.
Any idea?

SQL> @d:\oracle\ora81\rdbms\admin\utlrp.sql
from obj$ o, user$ u
*
ERROR at line 25:
ORA-06550: line 25, column 17:
PLS-00201: identifier 'OBJ$' must be declared
ORA-06550: line 4, column 15:
PL/SQL: SQL Statement ignored
ORA-06550: line 41, column 39:
PLS-00201: identifier 'OBJ$' must be declared
ORA-06550: line 41, column 2:
PL/SQL: SQL Statement ignored
ORA-06550: line 4, column 24:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 50, column 6:
PL/SQL: SQL Statement ignored
ORA-06550: line 68, column 39:
PLS-00201: identifier 'OBJ$' must be declared
ORA-06550: line 68, column 4:
PL/SQL: SQL Statement ignored

[Ablakios]

Please disregard the above post. I was running the script in a wrong schema.
Sorry.

[Mr.Hanky]

Originally posted by Ablakios
Please disregard the above post. I was running the script in a wrong schema.
Sorry.

D'OH!!

I hate when that happens!!
Especially when it is a truncate script!



MH

[DaPi]

Now if you had a login.sql that contained something like . . . .

column my_prom new_value myprom
set termout off
select lower(user)||'@'||lower(substr(global_name,1,4))||':'||lower(instance_name)||
'-'||initcap(host_name)||chr(10)||'SQL> ' my_prom from global_name, v$instance;
set sqlprompt '&myprom'

[pando]

set line 130
set serverout on
set pagesize 40
set termout off
col plan_plus_exp for a96

column sql_string new_value sql_string
column sqlpr new_value sqlpr

select case
       when isdba='DBA' or whoami='SYS'
       then 'lower(user) || ''@'' || instance_name || ''-'' || upper(host_name) sqlpr
             from v$instance'
       when isdba is null
       then 'lower(user) || ''@'' || substr(global_name, 1, decode(instr(global_name, ''.'', -1, 1), 0,
             length(global_name) + 1, instr(global_name, ''.'', -1, 1) ) - 1) sqlpr
             from global_name'
       end sql_string
  from (select role isdba, user whoami
          from (select user whoami from dual) b,
               (select user whoami, role from session_roles where role = 'DBA') a
         where a.whoami(+) = b.whoami);
 
select &sql_string;

set sqlprompt '&sqlpr>'

alter session set nls_date_format='YYYYMMDD HH24:MI:SS';

set termout on

[Ablakios]

Yes Mr.Hanky I hate that too. but tkx to everyone. I will just set my sqlprompt environment.
Thanks again everyone.