Re: newbie questions with Oracle 9i

system/manager is not correct. Use sys/change_on_install to create the database.

system/manager has been depreciated and will go away in some as yet unnamed future release.

HTH
tED
"KK" <moditha_at_yahoo.com> wrote in message news:469d2479.0111302227.74627c3f_at_posting.google.com...
> 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 - 04:10:22 CST