oracle 10gr2 minimal

Upload: malru

Post on 17-Feb-2018

219 views

Category:

Documents


0 download

TRANSCRIPT

  • 7/23/2019 Oracle 10gr2 Minimal

    1/1

    control_files = (/path/to/control1.ctl,/path/to/control2.ctl,/path/to/control3.ctl)undo_management = AUTundo_ta!lespace = U"#T$%1d!_name = testd!_!loc&_si'e = 12sga_ma*_si'e = 1+3-12- one gigsga_target = 1+3-12- one gig

    Create a password file

    0A_45/!in/orap6d file=0A_45/d!s/p6d7sid8.ora pass6ord=oracle entries=9

    Create the database

    create data!ase testlogfile group 1 (:/path/to/redo1.log:) si'e 1++5, group 2 (:/path/to/redo2.log:) si'e 1++5, group 3 (:/path/to/redo3.log:) si'e 1++5character set ;stem.d!f: si'e 9++5 autoe*tend on ne*t 1+5 ma*si'e unlimited e*tent management local

    s>sau* datafile :/path/to/s>sau*.d!f: si'e 1++5 autoe*tend on ne*t 1+5 ma*si'e unlimitedundo ta!lespace undot!s1 datafile :/path/to/undot!s1.d!f: si'e 1++5default temporar> ta!lespace temp tempfile :/path/to/temp+1.d!f: si'e 1++5?

    Note:there:s some other things >ou can do here, li&e @A04