Invalid Objects in Schema - SQL Help Needed
cmennensMay 14 2012 — edited May 14 2012I for some reason have some invalid OLAP objects according to Oracle support team and while I'm working with them to help get this corrected, I'm not an Oracle DBA so my ANSI SQL is poor. Oracle support is asking me to run the following command(s):
spool invalid_pre.lst
select substr(owner,1,12) owner,
substr(object_name,1,30) object,
substr(object_type,1,30) type, status from
dba_objects where status <>'VALID';
spool off
The problem I'm having is the above SQL statement dumps a large amount of data & my buffer scroll limit seems to cut off the 1st portion or some form of the output from the above command & I don't know how I can simply execute this command in SQL*Plus as SYSDBA & pipe the command results into a text file or perhaps a way I can cleanly copy / paste the entire output. I'm using Oracle 11g R2 on RHEL 5.7 Linux (64-bit) if that matters.
Thanks for any help!