Re: Table Problem

kenny,

in oracle you first have to create tablespace and then users for the newly created tablespaces. the SYSTEM is the user where the system information about oracle is stored, when you create a user without attachine it a ordinary tablespace, it gets attached to the system tablespace and thus you are seeing all the information when you execute your program.

run the following code:

1. create a tablespace

create tablespace kenny_tbsp_01
datafile 'C:\oradata\kenny_df_01.dbf'
size 50M;

2. next create the user

create user kenny identified by kenny123 default tablespace kenny_tbsp_01
temporary tablespace temp;

3. create all you objects in this user, and only the objects which you create will be stored here.

• there is nothing wrong in your vb program.

cheers,
vasant

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.
Received on Thu Feb 20 2003 - 12:53:19 CET