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!

Invalid Objects in Schema - SQL Help Needed

cmennensMay 14 2012 — edited May 14 2012
I 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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2012
Added on May 14 2012
6 comments
1,084 views