| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Deleting database
Ron,
I like this idea. Although, I am not really concerned about userid's or environmentals, truncating test tables and importing the new data in looks like it would be faster than deleting the entire test database and then recreating it. But how would I know what tables to truncate?
Thanks
Julio Cesar Quijada-Reina
Programmer Analyst
Computer Services at Alfred State College
-----Original Message-----
Ron Rogers
Sent: Tuesday, December 30, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Julio,
If you need to keep the userid's and other environmentals, I would
create a script that truncates the tables and then import the data to
populate them with the new data. The export can be controlled with a par
file and the import can be part of the truncate script.
Ron
>>> QuijadJC_at_alfredstate.edu 12/30/2003 11:54:32 AM >>> Hi All,
I have two databases of small size running on a Win2k Server. One is
production and the second one test. I would like to delete the test
database in an automated way (run a script say every weekend), then
recreate it so that I have a fresh database to work with or to import
prod data into. I have the scripts for database creation part done.
But,
I was wondering if there were any sample scripts for deleting a
database
without user interaction or at least know what steps I should follow.
Has anybody done this on his or her environment?
Your help will be appreciated!
Julio Cesar Quijada-Reina
Programmer Analyst
Computer Services at Alfred State College
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: QuijadaReina, Julio C
INET: QuijadJC_at_alfredstate.edu
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Dec 30 2003 - 11:29:40 CST
 |
 |