Some expert advise please.....

[JonMusto]

Hi all,

I've just installed Oracle 9i on Redhat 9 and i'm wondering what would be the best way to import customer database backups for support purposes??

i.e a customer will send us their oracle database dmp file for us to import and connect to. All we really need importing are the tables, views, etc..

would i need a separate SID for each customer... or can i have multiple databases under on SID. I come from a sql server background and am stuggling to understand how oracle works...

Any help would be great,
Many Thanks,

 

[alexhu]

If they are full exports you will need a seperate SID (or database) for each import.

If they are only schema (user) exports they can be put in the same database (as long as the schema names are different)

Another consideration is the versions of Oracle you clients are running - are they all the same? For support purposes would you not need to match the versions ?

Alex

 

[JonMusto]

We just need to be able to get into the database so that we can run some SQL queries against it...

Does anyone have any links to any good guides to creating a new SID and importing a .dmp file into it?

Thanks for your help...

 

[alexhu]

http://tahiti.oracle.com/

Alex