| new to dataware housing [message #55803] |
Mon, 17 February 2003 12:02  |
pavani
Messages: 32
Registered: April 2002
|
Member |
|
|
hi
i'm new to data ware housing so...can any one help me in knowing what is NOLOGGING used for and what is a TABLESPACE
thanks in advance.
|
|
|
|
| Re: new to dataware housing [message #55806 is a reply to message #55803] |
Mon, 17 February 2003 12:41  |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
Hello,
Braodly
Database data is stored in terms of Data Blocks (size of 512 or Multiples of 512 bytes) at the O.S level and the files are called as Data Files..
so u can say Oracle's data is stored in Data files ..
Like system01.dbf, etc etc ...Logical Collection of Datafiles are called as Tablespaces ..
(i.e. ) a tablespace is a collection of Datafiles..
Evry user / table will be having a Tablespace defined with them so that their concerned data will sit in its corresponding data files..
Ref to Oracle 8i Admin guide for Furthur reference
create table tab1(a number, b number) nologging ;
if u say this , the above command will not geberate Redo (entries in redo log files), hence it will be very fast in execution ...But if by some means if the operation is not successfull u cannot Recover the statement . ..
Hope that helps...
sai
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
