Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

what files does Oracle creates for a database

buggy84buggy84 Member Posts: 23
hello
needs to know that what file the oracle system creates for a database
and its tables what are their names and extensions ans their purpose plz lemme know

Comments

  • infidelinfidel Member Posts: 2,900
    : hello
    : needs to know that what file the oracle system creates for a database
    : and its tables what are their names and extensions ans their purpose plz lemme know

    A database is a collection of datafiles. They can be named anything, but by convention have the extension .dbf. There's usually one file for each tablespace in your database, and it's a good idea to name them after the tablespace they contain. For example:

    system01.dbf
    xdb01.dbf
    temp01.dbf
    undo01.dbf

    There are also the redo logs which are redo01.log, redo02.log, etc (you specify how many there are when you create the database.

    Your instance also needs three control files control01.ctl, control02.ctl and control03.ctl. On my win2000 machine, they are all located together in C:OracleOra92oradata, but you can put them almost anywhere. The control files tell your instance where to find them, and your initXXXXX.ora (replace XXXXX with the name of your instance) file tells your instance where to find the control files. There's also the listener.ora and tnsnames.ora files. All the .ora files are like plain text configuration files that tell Oracle where to find things and on which ports to listen for connections, etc etc etc. There's also a password file.


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

Sign In or Register to comment.