 Please help me understand a basic concept. [message #476852] |
Sun, 26 September 2010 20:25  |
gromit
Messages: 3
Registered: September 2010
Location: NY
|
Junior Member |
|
|
First off, thank you for the web site. I have found much needed info here about Oracle.
So far I have dealt only with MS-SQL at work.
And as you can understand I have learned some things the MS way.
Here is where I get all confused.
In MS Enterprise Manager, I can connect to a database engine and see all the current databases hosted on that engine.
I can right click on one of those databases and see all its tables.
It is my understanding however that Oracle has schemas.
So let us say I have created 5 different oracle databases (in the MS-SQL sense) and I want to view one of them and what tables it has how I do that?
Are tables that form a schema (database in the MS sense) in Oracle not contained in a file such a *.DBF file
?
Can't I have empty shells where I can attach to the database engine it self?
I am confused. Help?  
[Updated on: Sun, 26 September 2010 20:28] Report message to a moderator |
|
|
|
|
|
| Re: Please help me understand a basic concept. [message #476854 is a reply to message #476853] |
Sun, 26 September 2010 20:35  |
gromit
Messages: 3
Registered: September 2010
Location: NY
|
Junior Member |
|
|
Nice link. I was looking for something like that.
So far I kept finding bits and pieces of info.
I am studying on my self by using the book Oracle 11g SQL by Joan Castee and while I was doing some of the homework (altering, droping tables) all these questions on how these things work in the background came in my head. Especially when I played around with creating users and the term tablespace came about.
I want to know what these things are Vs just doing blindly the assignments.
Thank you.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
