Just for info of list members: <http://otnxchange.oracle.com/expert_advice_marketplace.html> OTN Expert Advice Marketplace Expert Advice provides an opportunity for developers to get answers to questions beyond Oracle Technology. Where as OTN discussion forums provide instant access to Oracle specific technology experts, Expert Advice provides instant access to experts who have knowledge that are beyond Oracle like operating systems, languages, networking, hardware, graphics, application software and web development software. Experts Exchange is a leader in IT professional collaboration network. It provides a platform for developers to share knowledge quickly and efficiently and has more than million validated IT solutions in its knowledge bank and is actively supported by over 400,000 members and 70,000 experts. Join the community and benefit from shared knowledge. Enjoy, Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 02 Feb 2001 08:10:59 -0800 Glenn, dba_temp_files will be populated when you create a temporary tablespace. e.g. create temporary tablespace temp tempfile '/oradata/temp01.dbf' size 1000m; Jared On Thu, 1 Feb 2001, Glenn Travis wrote: > What is usually in dba_temp_files? Mine has zero rows (all day). If you > shutdown and restart Oracle, will this table be empty? > > > -----Original Message----- > > From: Igor Polishchuk [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 30, 2001 9:38 PM > > To: 'Glenn Travis'; Woody Mckay; [EMAIL PROTECTED]; > > [EMAIL PROTECTED] > > Subject: RE: How to drop a database > > > > > > Hi Glenn > > You missed temporary files, that may be associated with database > > Velow is my script that creates script for database deleting and includes > > temporary files too. But it is necessary to be careful with it :) > > > > # This script shutdown current database and delete all files for > > #c # this > > database > > # > > # > > sqlplus -s internal << EOF > > spool _rm_files.sh > > set head off feedback off pages 0 > > > > select 'rm '|| file_name > > from dba_data_files; > > > > select 'rm '|| file_name > > from dba_temp_files; > > > > select 'rm '|| name > > from v\$controlfile; > > > > select 'rm '|| member > > from v\$logfile; > > > > prompt rm $ORACLE_HOME/dbs/orapw$ORACLE_SID > > > > spool off > > > > shutdown abort > > > > EOF > > > > chmod u+x ./_rm_files.sh > > > > #./_rm_files.sh > > > > > > > > Igor Polishchuk > > IT department > > DigitalThink > > (415) 625 4285 > > e-mail: [EMAIL PROTECTED] > > > > > > -----Original Message----- > > From: Glenn Travis [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 30, 2001 11:06 AM > > To: Woody Mckay; [EMAIL PROTECTED]; [EMAIL PROTECTED] > > Subject: RE: How to drop a database > > > > > > Here's a script I wrote to list all the files associated with the > > database. > > List, did I miss any? > > _______________________ > > break on today > > column today noprint new_value xdate > > select substr(to_char(sysdate,'fmMonth DD, YYYY HH:MI:SS > > P.M.'),1,35) today > > from dual; > > column name noprint new_value dbname > > column created noprint new_value dbcreated > > column host_name noprint new_value hostname > > select name,created from v$database; > > select host_name from v$instance; > > > > spool &dbname..&hostname..databasefiles.out > > > > prompt Date: &xdate > > prompt DATABASE: &dbname > > prompt HOST: &hostname > > prompt Created: &dbcreated > > prompt > > prompt **************************** > > prompt ***** Database Files ***** > > prompt **************************** > > prompt > > > > set head off echo off pagesize 0 trimspool on feed off linesize 132 > > > > clear columns > > col ftype format a15 > > col tbspc format a20 > > col fname format a50 > > > > select 'Controlfile' ftype, name fname , ' ' tbspc > > from SYS.V_$CONTROLFILE > > union > > select 'Logfile' ftype, member fname, ' ' tbspc > > from SYS.V_$LOGFILE > > union > > select 'Tablespace' ftype, file_name fname, > > '('||tablespace_name||')' tbspc > > from DBA_DATA_FILES > > order by 2; > > > > spool off > > prompt > > prompt Output in &dbname..&hostname..databasefiles.out > > prompt > > quit > > _____________________ > > > > > > > -----Original Message----- > > > From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, January 30, 2001 1:08 PM > > > To: Woody Mckay; [EMAIL PROTECTED]; [EMAIL PROTECTED] > > > Subject: Re: How to drop a database > > > > > > > > > There is not command to drop a database. You just have to > > remove all of > > > the files associated with that database: control files, datafiles, etc. > > > > > > Ruth > > > ----- Original Message ----- > > > From: "Woody Mckay" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > > Sent: Tuesday, January 30, 2001 12:51 PM > > > Subject: How to drop a database > > > > > > > > > > Hello all, > > > > > > > > Sorry to ask what might be a dumb question, but a friend > > wants to drop a > > > > test database (Solaris/Oracle 8.1.7) and I can't seem to find > > the right > > > > command(s). > > > > > > > > Would it be a series of alter database drop xxx? > > > > > > > > Thanks for any help. > > > > > > > > Woody > > > > > > > > > > > > -------- > > > > Think you know someone who can answer the above question? > > Forward it to > > > them! > > > > to unsubscribe, send a blank email to > > [EMAIL PROTECTED] > > > > to subscribe send a blank email to [EMAIL PROTECTED] > > > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > > > > > > > > > > > > > -------- > > > Think you know someone who can answer the above question? Forward > > > it to them! > > > to unsubscribe, send a blank email to [EMAIL PROTECTED] > > > to subscribe send a blank email to [EMAIL PROTECTED] > > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > > > > > > > > > -------- > > Think you know someone who can answer the above question? Forward it to > > them! > > to unsubscribe, send a blank email to [EMAIL PROTECTED] > > to subscribe send a blank email to [EMAIL PROTECTED] > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Glenn Travis > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
