| Newbie... need directions [message #99666] |
Tue, 12 February 2002 16:32  |
Todd Williamsen
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
Ok,
I am quite familiar with MS SQL Server and mySQL, but never touched Oracle, but would like to.
I have Win2k w/SP2 and I have Oracle 8.04 installed(so I think).
Now what?
What I would like to do is interface with Oracle with PHP(i know its possible)
Now, I would like to know what do I do for basic administration like:
logging in(default username and password) and what do I launch to do that?
how do I create tables, database etc?
Thanks..
Don't mean to be a nuisance, but Oracle's website isn't very helpful and either is the documentation that came with this damn thing
|
|
|
|
| Re: Newbie... need directions [message #99688 is a reply to message #99666] |
Tue, 19 February 2002 06:42  |
Bricklen Anderson
Messages: 3
Registered: February 2002
|
Junior Member |
|
|
connect sys/change_on_install (the dba)
connect system/manager (similar)
connect scott/tiger (default, already has tables etc.great place to start)
connect demo/demo (if there is no scott/tiger)
create an account at oracle.com (or the tech part of it otn.com etc.). this allows you to reference the documentation at http://tahiti.oracle.com
always use the scott/tiger combo to create stuff in the db, otherwise you'll end up creating your objects in the SYSTEM tablespace, which is a big no-no.
find the file called sqlplusw.exe under your oracle home directory
(eg. c:oracleora81binsqlplusw.exe)
That is the main tool to use, and has a ton of uses (once you get to know them).
That should get you started.
Good luck.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
