Learning DB admin in Oracle

hi friends
let us teach each other the DBA role in oracle

please if any one can explain that what is the difference between logical and physical structures of oracle data base.....in non-technical terms

hi friends
please tell me the fast methods of importing data into the oracle database
and which one is best ?

hi, i'm new to Geek. I wud like to get OCP. pls be patient i'll get back soon

[QUOTE=aardvax;11651]please if any one can explain that what is the difference between logical and physical structures of oracle data base.....in non-technical terms[/QUOTE]

Hi aardvax,

Physical structures are those files which are physically present in the Hard disk (physical space).
Datafiles, control files, Redo log files, Archive log files, parameter files, etc are physical database structures.
Logical Database structures are logically allocated in the real physical space.
Tablespaces, Datablocks, Extents, Segments are logical structures.

[QUOTE=aardvax;11663]hi friends
please tell me the fast methods of importing data into the oracle database
and which one is best ?[/QUOTE]

Hi aardvax,

Its a nice idea to discuss about DBA activities. :cool:
I think copying the data files is the fastest recovery method than importing the tables into the database.