| Need to design new database.. [message #421854] |
Fri, 11 September 2009 03:10  |
abhi_shakya
Messages: 50
Registered: September 2009
Location: Nepal
|
Member |
|
|
|
I have the required tables ...but if i will create all the tables in the database itself ..it will take loads of time and will be harder to alter the definitions later..i also need to load same design in 20 servers...now give me the idea to design database using different tool where i mustnot create table in oracle itself..and work independently and then after completion i only need to run a script to create the required schemas and tables...
|
|
|
|
| Re: Need to design new database.. [message #421860 is a reply to message #421854] |
Fri, 11 September 2009 04:12  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Why do you think so? Designer can create everything you need, but you can always alter tables (or whatever you want to do) later by running a single statement (or put many of them into a script) such as ALTER TABLE ADD COLUMN or CREATE INDEX or ...
Perhaps you could create a database and, once you are satisfied with it, distribute it over 20 servers using export/import utilities (or data pump, if available).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
