Thread: Learning DB admin in Oracle

Originally Posted by aardvax

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 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.

Originally Posted by aardvax

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

Hi aardvax,

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