Yes. thats the point. The first thing i tried was to create a new table
and it still does not work.
Hans Forbrich wrote:
> Sherlock wrote:
>
>
>>Greetings,
>>
>>I am using Oracle 9i on Windows 2000. I came across a weird problem (?)
>>while creating a new user. A schema, i understand is a collection of
>>objects owned by a User. To create a new user, i first create a new
>>tablespace for that user. After that i create a new user and assign the
>>tablespace to him. I understand that 'create user test identified by
>>test' command will create a new schema, called test.
>>But when i create a user yesterday in the enterprise manager, a new user
>>is shown. But a new schema is not shown in the enterprise manager. I can
>>see the user i created under "Security-->Users", but not under "Schema"
>>I have created 5-6 users earlier, but have not experienced this problem(?).
>
>
> The direct answer is: if your user is capable of holding objects, then the
> moment you add an object it will show up under the Schema section. I just test
> this - same environment.
>
> However, and with all due respect, what documentation have you read to provide
> the definition of User, Schema, Tablespace, etc. I believe your problem
> statement indicates some fundamental confusion & the long answer of trying to
> unravel the confusion might be better.
>
>
Received on Wed May 21 2003 - 21:35:41 CDT
