Home » Other » General » Please help me understand a basic concept. (Oragle 11G, Centos 5 64bit.)
icon5.gif  Please help me understand a basic concept. [message #476852] Sun, 26 September 2010 20:25 Go to next message
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? Embarassed Confused

[Updated on: Sun, 26 September 2010 20:28]

Report message to a moderator

Re: Please help me understand a basic concept. [message #476853 is a reply to message #476852] Sun, 26 September 2010 20:30 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please take as much time as needed to Read This Fine Manual

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm

> I want to view all of them how do I do it?
query DBA_USERS

>Are tables that form a schema (database in the MS sense) in Oracle not contained in a file such a *.DBF file
TABLE reside in tablespace & tablespace is comprised of 1 or more data files.

>Can't I have empty shells where I can attach to the database engine it self?
What is a "shell"?
In Oracle a USER can exist that does not own any objects.
Re: Please help me understand a basic concept. [message #476854 is a reply to message #476853] Sun, 26 September 2010 20:35 Go to previous messageGo to next message
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.
Re: Please help me understand a basic concept. [message #476855 is a reply to message #476854] Sun, 26 September 2010 20:46 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
The whole Oracle Documentation Set can be found at
http://tahiti.oracle.com

Many fine coding examples an be found at http://asktom.oracle.com

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Please help me understand a basic concept. [message #476856 is a reply to message #476855] Sun, 26 September 2010 20:51 Go to previous message
gromit
Messages: 3
Registered: September 2010
Location: NY
Junior Member
Great links.

Thank you Swan Smile
Previous Topic: About Execution Plan
Next Topic: Inside Buffer Cache
Goto Forum:
  


Current Time: Thu Mar 28 06:49:04 CDT 2024