DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: combine physical structure

  1. #1
    Join Date
    May 2006
    Posts
    51

    combine physical structure

    Can anyone guide me whether it is ok to combine physical sturcture- table,index,trigger,sequence, synonym and constraint under one create script. I mean can we declare all these under create table scripts for a db instance

    Thanks for your input

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    What's the alternative?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    May 2006
    Posts
    51
    Slime dave what do you mean by alternative! I want to cofirm it is ok to have all in one single create script instead of individual scripts

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what difference does it make?

    a script is a script is a script, the database doesnt care whats in it

    what angle are you coming from here?

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by davey23uk
    what difference does it make?

    a script is a script is a script, the database doesnt care whats in it

    what angle are you coming from here?
    I worked at a place where the ddl for every database was in a separate file, separated by directory. Tables in onw directory indexeses in another. so that when something was checked into version control it would be easier for people who didn't understand Oracle could see what was changed. They did a lot of other things that didn't make any sense as well. I think that it can make sense to break out user creates and grants, from tablespace, from indexes and table from stored procedures, functions and packages. But it really depends on the kind of ddl that you are keeping.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    cant see why it helps, its just ddl - you either understabd what it does or you dont - putting in different scripts wont help that

  7. #7
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Quote Originally Posted by davey23uk
    cant see why it helps, its just ddl - you either understabd what it does or you dont - putting in different scripts wont help that
    Unless you have multiple developers checking in code in different files.
    Most likely changing stored procedures.

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