Results 1 to 6 of 6

Thread: Learning DB admin in Oracle

  1. #1
    Contributing Member
    Join Date
    Jan 2007
    Answers
    33

    Learning DB admin in Oracle

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


  2. #2
    Contributing Member
    Join Date
    Jan 2007
    Answers
    33

    Re: Learning DB admin 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


  3. #3
    Contributing Member
    Join Date
    Jan 2007
    Answers
    33

    Re: Learning DB admin in Oracle

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


  4. #4
    Junior Member
    Join Date
    Jan 2007
    Answers
    2

    Re: Learning DB admin in Oracle

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


  5. #5
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    Re: Learning DB admin in Oracle

    Quote Originally Posted by aardvax View Post
    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.

    *** Innila ***

  6. #6
    Expert Member
    Join Date
    Sep 2006
    Answers
    130

    Re: Learning DB admin in Oracle

    Quote Originally Posted by aardvax View Post
    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.

    Last edited by Innila; 05-25-2007 at 05:47 AM.
    *** Innila ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact