My first Oracle PL/SQL class and my first install. Have used Oracle 8i in past but had a DBA to do the setup. I installed 9i without a DB. Now I don't know how to set up connection strings, login to SQLplus (no Scott/Tiger) and create my first DB. Can anyone point me to an online Oracle DBA for dummies tutorial?
DATAFILE filespec AUTOEXTEND OFF
DATAFILE filespec AUTOEXTEND ON [NEXT int K | M] [MAXSIZE int K | M]
LOGFILE [GROUP int] filespec
CHARACTER SET charset
If more than one DATAFILE or LOGFILE is to be specified - several 'filespecs' can be included in one clause separated with commas e.g. DATAFILE filespec1, filespec2, filespec3
thanks R. I am using Oracle 9i for NT on an XP. I made some progress yesterday by using the Database Configuration Assistant tool which apparently sets up the init.ora file. I was able to login as system and create a user so I believe that I am more or less up and working.
However, I have a dumb question that you might be able to answer for me if you would be so kind. I have not been able to find the answer to this by search the web and I am waiting for an Oracle book to arrive in the mail which may clarify all of my questions hopefully, but...
Since I opted not to install the demonstration Scott/Tiger database, I am trying to set up a user with the same level of permissions that Scott/Tiger would have had (then I have a script to create my class specific database). Two questions -
1) Do you know what permissions Scott/Tiger user has in Oracle or would you know of a command that would list the permissions that I could use on my schools' database to find out?
2) When granting persmissions to a user of CREATE SESSION and CREATE TABLE why I would get an error on a grant for DROP TABLE? SQL+ feels that this is an invalid privilege.