newbie questions with Oracle 9i

Hi

These are my questions.

1. I connect to Oracle9i using system/manager which is super user as I know. I created a new database using the above account. then was exploring the newly created database using Enterprice manager. I saw SYSTEM account is listed in that databases users list. but now it dosen't show there.!!! its vanished.. but still I can connect to the database as SYSTEM.. whats happening? and how can i get that user back ?
2. after login as system to the newly created database, I created a table, table schema name i choosed as same as the database name, and the tablespace i choosed as USERS [which was already there by default] table got created successfully.
3. Can i give permission to a user , for more than 1 table space ?? apart from the temporary tablespace and default tablespace is it possible to add more tablespace for his access?
4. Where the hell is Oracle SQL syntax help? :o) When I choose enterprice manager help, it dosen't seem to have any help about PL/SQL or SQL* help...

Regareds
KK Received on Sat Dec 01 2001 - 00:27:17 CST