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
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.