Re: How to restore over an existing DB

RobbMichel_at_gmail.com wrote:
> The goal is to query the data in the Oracle database and move it into
> our SQL database. We get the data from a client (they only know how to
> send a dmp), and we do not use Oracle here we use SQL.

SQL is a language not a product.

I presume you use SQL Server.

> We just have an Oracle test enviroment to practice writing queries to
> get data from the client's Oracle database. So we threw together an
> Oracle enviroment to allow easier development. The developer wanted
> more recent data than the last dump we imported and we are now in this
> situation. We have about 4 employees total and can not just hire a new
> person to monitor this enviroment. That is why I am using gooogle
> groups to discuss the problems we are having. I have gotten great
> advice from google groups in the past.

You probably should write a script to drop the existing user:

DROP USER <user_name> CASCADE;

then recreate the user and permissions

before running the import.

What is fascinating is that you are doing this at all. Why not just do it all in Oracle and save yourselves a lot of trouble while enhancing your resume?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org