Help Needed : Database Design
Posted by: Devrishi Shandilya
Date: November 26, 2014 04:43AM

Hi Friends,

I have a database schema and one client using it currently with application. it has 50 tables which is in use out of 110. Now a another client want to use the same schema with different format of data. What are the best desing in terms of a DBA ? what would you prefer ? Please specify with pros and cons of each design.

1- Alter the same tables, views, procedures, functions according to second client.
2- Create separate tables, views, functions, procedures according to new client.

Regards,
Devrishi

Options: ReplyQuote


Subject
Written By
Posted
Help Needed : Database Design
November 26, 2014 04:43AM
November 28, 2014 12:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.