Click here to Skip to main content
15,899,025 members
Home / Discussions / Database
   

Database

 
QuestionRe: complicated select Pin
Chris Meech3-Mar-11 8:45
Chris Meech3-Mar-11 8:45 
AnswerRe: complicated select Pin
Jörgen Andersson3-Mar-11 9:37
professionalJörgen Andersson3-Mar-11 9:37 
AnswerRe: complicated select Pin
Mycroft Holmes3-Mar-11 13:52
professionalMycroft Holmes3-Mar-11 13:52 
GeneralRe: complicated select Pin
benams4-Mar-11 7:35
benams4-Mar-11 7:35 
GeneralRe: complicated select Pin
Mycroft Holmes4-Mar-11 12:49
professionalMycroft Holmes4-Mar-11 12:49 
QuestionOracle Multiple schemas Vs single schemas Pin
V.2-Mar-11 20:11
professionalV.2-Mar-11 20:11 
AnswerRe: Oracle Multiple schemas Vs single schemas Pin
Jörgen Andersson2-Mar-11 21:08
professionalJörgen Andersson2-Mar-11 21:08 
AnswerRe: Oracle Multiple schemas Vs single schemas Pin
Mycroft Holmes2-Mar-11 22:17
professionalMycroft Holmes2-Mar-11 22:17 
I'm pretty sure tablespaces have nothing to do with your segregation of data, it is only for logical storage.

We have just run across a real need for additional schemas, we want to move the production data (ETLd from other systems) to the dev server, if the data was in different schemas this would be simple, now we have to reengineer the database schemas to meet that requirement.

Security is another issue so I would go for the additional schemas from the start. As for moving from 1 schema to anoter I believe there are tools to help (Toad) and it is just the price you pay for getting it wrong (or changing requirements).
Never underestimate the power of human stupidity
RAH

AnswerRe: Oracle Multiple schemas Vs single schemas Pin
PIEBALDconsult3-Mar-11 1:56
mvePIEBALDconsult3-Mar-11 1:56 
AnswerRe: Oracle Multiple schemas Vs single schemas Pin
Wendelius4-Mar-11 10:28
mentorWendelius4-Mar-11 10:28 
GeneralRe: Oracle Multiple schemas Vs single schemas Pin
V.4-Mar-11 10:48
professionalV.4-Mar-11 10:48 
GeneralRe: Oracle Multiple schemas Vs single schemas Pin
Wendelius4-Mar-11 10:54
mentorWendelius4-Mar-11 10:54 
QuestionHow to write a SQL query to present values horizontally sql server 2005 Pin
Tridip Bhattacharjee1-Mar-11 20:10
professionalTridip Bhattacharjee1-Mar-11 20:10 
AnswerRe: How to write a SQL query to present values horizontally sql server 2005 Pin
Jörgen Andersson1-Mar-11 20:27
professionalJörgen Andersson1-Mar-11 20:27 
AnswerRe: How to write a SQL query to present values horizontally sql server 2005 Pin
Mycroft Holmes1-Mar-11 21:49
professionalMycroft Holmes1-Mar-11 21:49 
GeneralRe: How to write a SQL query to present values horizontally sql server 2005 Pin
Wendelius4-Mar-11 10:37
mentorWendelius4-Mar-11 10:37 
AnswerRe: How to write a SQL query to present values horizontally sql server 2005 Pin
PIEBALDconsult2-Mar-11 2:18
mvePIEBALDconsult2-Mar-11 2:18 
Questiondatabase design Pin
wjbjnr1-Mar-11 9:27
wjbjnr1-Mar-11 9:27 
AnswerRe: database design Pin
Mycroft Holmes1-Mar-11 21:52
professionalMycroft Holmes1-Mar-11 21:52 
AnswerRe: database design Pin
thatraja2-Mar-11 12:32
professionalthatraja2-Mar-11 12:32 
AnswerRe: database design Pin
V.2-Mar-11 20:14
professionalV.2-Mar-11 20:14 
AnswerRe: database design Pin
Wendelius4-Mar-11 10:34
mentorWendelius4-Mar-11 10:34 
QuestionCan't get my query to work on a form! Pin
venomation1-Mar-11 3:06
venomation1-Mar-11 3:06 
Questionif database crashes how to recover in sql server 2008 Pin
vinu.111128-Feb-11 21:15
vinu.111128-Feb-11 21:15 
AnswerRe: if database crashes how to recover in sql server 2008 Pin
Mycroft Holmes28-Feb-11 23:01
professionalMycroft Holmes28-Feb-11 23:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.