Schema is not auto generated when creating a user in Oracle9i database?

Hi all,


i am new to Oracle db. My understanding is that the schema should be auto generated when creating a user. I am able to successfully create a user by using SQL + or by using create user window. but the schema is not generated.





I need the schema to be generated, and the tables i create should be created inside that schema. any help?





Thank you in advance!Schema is not auto generated when creating a user in Oracle9i database?
Hi Kartik,





In Oracle 9i, when you create a user the schema is actually created only when the user makes first use of its schema. This is because only then the recursive SQL's are fired that creates schema.





This phenomena is seem else where too. When you drop a table, the table is physically dropped, however, not immediately dropped from schema logically. In case, you fire a statement that makes the use of same table, Oracle updates the Schema that table is actually dropped.





This would be a case of invalidation in database where user just gets the normal error (table doesn't exist), however, unnessasary parsing happens in database.





Hope it helps