Re: newbie questions with Oracle 9i

Totally, 100%, incorrect.

System/manager is *not* deprecated, and is not going away in any future release. You're thinking of "internal", which is also not deprecated -it just doesn't work any more.

HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Ted McCabe" <theom_at_gte.net> wrote in message
news:h02O7.1427$005.1556552_at_paloalto-snr2.gtei.net...


> 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

>

>