Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Deleting database

RE: Deleting database

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 30 Dec 2003 10:34:26 -0800
Message-ID: <F001.005DB46E.20031230103426@fatcity.com>


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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ron Rogers
  INET: RROGERS_at_galottery.org
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).
--

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ron Rogers
  INET: RROGERS_at_galottery.org
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US