DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2001



    I have an Oracle database which I have to dumb to an ASCII file of a defined format. For that I need to read the whole database, including table names, column names and descriptions, format the data and write the file.

    So, how do I :
    - Find out all the table names
    - Find out column names in a certain table

    I'm programming this with Delphi and I think I'll be able to do rest of the data processing, I just need to extract all the data. Is it possible to do all this using a database user or do I have to log on as system user?

    I got the table names and column names queries working in SQL*Plus, but now I need to do this with a database user and from an external program.

    Thanks for the help!

  2. #2
    Join Date
    Jan 2001
    to find out all the tables in the databse you will have to have select priveleiges on the following views

    dba_tables for all tables
    dba_tab_columns for all columns


  3. #3
    Join Date
    Apr 2001
    Hmm, I tried to query those tables, but Oracle responded with a null string. Apparently I don't have the select privileges. How do I get them?

  4. #4
    Join Date
    Jan 2001

    System Privledge

    Sys has to grant your user select on those tables. Make sure they are granted directly to a user and not a role because when you are using procedures or functions the role privledges won't work.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.