| 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
Julio,
You can get a list if tables from the test database and compare it
with a list of tables from the production database. Just select
table_name from dba_tables where owner not = system or sys and that will
give you all of the application tables in the database.
Ron
>>> QuijadJC_at_alfredstate.edu 12/30/2003 12:29:40 PM >>> 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).
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 - 12:34:26 CST
 |
 |