Creating Fresh OLTP DB!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Creating Fresh OLTP DB!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi!

    We are going to create a new database.

    Queries:

    1.DB OLTP.
    2.How to manage backend triggers.
    3.Other necessary inputs,suggestions like PMON,SMON,
    DBWR,CKPT,Multiplexing of Control Files,On-line Redo Log Files.
    3.No datas exists as of now on the tables.
    4.We have to run scripts for tables,constraints creation.

    Regards,

    Amitstora.



  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    So may I ask what is the question

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    Use the Dbassist utilty supplied by oracle to create the databse and specify that you want an OLTP database oracle autonatically creates the oltp database for you.monitor these
    for a period of time when you populate it with data for growth then you can go ahead and alter it with the same tool.


    For craetion of table scripts etc if you have the ERD with you you can automatically generate triggers,table creation scripts with tools like erwin,etc


    regards
    hrishy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width