I'm trying to get metadata back on how I'm creating my database objects. The one reason which brought this need up for me recently is because I have forgotten the exact name of the file I supplied for LOCATION in my attempt to create an external table. I need to get that filename and so I am trying to use the SQL statement in the image to get this data.
But it seems it only wants to tease me with information. Do I have to put an extra quarter in the machine to get the full listing? How do I get it all?
***EDIT***: Okay, I found the "easier" way is to just use Oracle CL's new DDL command and it works wonderfully. Still, if somebody can explain why doing it the hard way only yields partial results it would be interesting.