OTN info

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: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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:ipolishchuk_at_digitalthink.com]
> > Sent: Tuesday, January 30, 2001 9:38 PM
> > To: 'Glenn Travis'; Woody Mckay; ORACLE-L_at_fatcity.com;
> > oracledba_at_lazydba.com
> > 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: ipolishchuk_at_digitalthink.com
> >
> >
> > -----Original Message-----
> > From: Glenn Travis [mailto:Glenn.Travis_at_wcom.com]
> > Sent: Tuesday, January 30, 2001 11:06 AM
> > To: Woody Mckay; ORACLE-L_at_fatcity.com; oracledba_at_lazydba.com
> > 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:rgramolini_at_tax.state.vt.us]
> > > Sent: Tuesday, January 30, 2001 1:08 PM
> > > To: Woody Mckay; ORACLE-L_at_fatcity.com; oracledba_at_lazydba.com
> > > 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" <wmckay_at_hydrogenmedia.com>
> > > To: <ORACLE-L_at_fatcity.com>; <oracledba_at_lazydba.com>
> > > 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
> > oracledba-unsubscribe_at_LAZYDBA.com
> > > > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > > > 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
oracledba-unsubscribe_at_LAZYDBA.com
> > > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > > 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 oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > 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: Glenn.Travis_at_wcom.com
>
> 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: 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.com
--
Author:
   INET: jkstill_at_cybcon.com

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

_________________________________________________________________
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: rafiq9857_at_hotmail.com

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