DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 13

Thread: ora-06502 sometimes

Threaded View

  1. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Originally posted by DBAtrix
    i made those changes, with the same result (ora-6502). any ideas why the query by itself is okay, but as an inline view the query fails?
    IF you do a "SELECT file_name FROM dba_data_files;", what do you get?

    I'm thinking the problem relates to the data that you are bringing back.
    Do you have any files located in the root directory?
    Last edited by gandolf989; 12-28-2004 at 12:04 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width