| help me!! [message #37338] |
Thu, 31 January 2002 18:55  |
sujung
Messages: 1
Registered: January 2002
|
Junior Member |
|
|
1. what are the differences between tables and views?
provide practical exaples where table s can be used and where views need to be used..
2. what are tablespaces and datafiles. can i have mulple tablespaces for one oracle dataspace.
|
|
|
|
| From SR [message #37342 is a reply to message #37338] |
Fri, 01 February 2002 00:24  |
ramu
Messages: 82
Registered: February 2001
|
Member |
|
|
Hi Sujung,
Basic difference between a table and a view is table can store data and view is something like a window through which u peep. Views are also called logical tables. Views are not for storing datas but to retrieve datas from tables. If u have a view created based on single table then u can do dml operations based on view created.
Yes u can have several tablespaces in a orion db.
|
|
|
|
| Re: From SR [message #37397 is a reply to message #37342] |
Wed, 06 February 2002 03:57 |
Armani D
Messages: 19
Registered: February 2002
|
Junior Member |
|
|
Sujung,
I suggest you get your hands on a copy of the Oracle 9i DBA handbook. It will help answer some of your elemntal Oracle questions like you posted.
Good Luck!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
