Re: Table Problem

kennypoon <member6892_at_dbforums.com> wrote in message news:<2551473.1045710042_at_dbforums.com>...
> When I use SYSTEM to login to SQL-PLUS, and then create a user, called
> tempUSER, then use the tablespace as tempUSER. After that, I logout
> SQL-PLUS, and then use tempUSER to login to SQL-PLUS. Then i create a
> table called employee with several fields, and it successful created.
> Then i use VB to write a program, use ADO to connect to the database.
>
> Set m_RecordSet = New ADODB.Recordset
> Set m_RecordSet = conn.OpenSchema(adSchemaTables, Array(Empty, Empty,
> Empty, "TABLE"))
> m_RecordSet.Sort = "TABLE_NAME"
>
> Do While Not m_RecordSet.EOF
> Debug.Print m_RecordSet!Table_Name
> m_RecordSet.MoveNext
> Loop
>
> Then why the result is not just display the employee table, it will
> display a lot of tables, such as some system table. So what's wrong with
> my Oracle setting, or what's wrong in my program.

ADO. selects from all_tables instead of user_tables. Complaints with William H Gates III

Regards

Sybrand Bakker
Senior Oracle DBA Received on Thu Feb 20 2003 - 11:52:22 CET