recovery during refresh

: Tatireddy, Shrinivas (MED, Keane) 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

RE: recovery during refresh

, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

update database trigger

give any hints. Thnx in advance Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: select data using trigger

: Tuesday, December 11, 2001 11:56 AM To: [EMAIL PROTECTED]; Tatireddy, Shrinivas (MED, Keane) Hope I'm not being blunt here, ( I will admit to being frank, but not Frank ) What you're suggesting here is to put a patch on a bad design. 15 indexes? That's too many. Your table is undoubtedly highly

excel data into oracle through sql loader

in excelsheet. (should I change any options for the sheet) Thnx in advance, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Database strange behaviour

is the db is running in NOARCHIVE mode and ARCH process is started. Thnx in advance Srinvias -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Out put in a single line

, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

select data using trigger

to divert that query to CONT2. As the applications are already tuned, we were not permitted to modify that code.) Thnx in advance, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network

RE: Out put in a single line

ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

parallel import

: Tatireddy, Shrinivas (MED, Keane) 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

Redo sql from archive log

HI lists, Can anybody tell me how to generate the sql s from archive log? what query do I user? Thnx in adv. Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: Installing Oracle on Linux

') 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: Tatireddy, Shrinivas

RE: parallel import

and MAX_SERVERS in init for doing parallel executions.? And can you post me the syntax for paralle exp / imp ? srinivas -Original Message- Sent: Saturday, December 08, 2001 1:30 PM To: Multiple recipients of list ORACLE-L Tatireddy, Shrinivas (MED, Keane) wrote: Hi lists

RE: statspack interpretations

anybody have any document / link for statspack report intepretations. if yes, can you please forward. Thnx and Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services

rollback for temp tablespace

ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: rollback for temp tablespace

is for mods to the data dictionary as your segments are created. hth connor --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists, Can anybody clarify this: Do the sort/idx rebuild etc.,(tasks that use temp tablespace), use rollback segments? I need to rebuild

statspack interpretations

. if yes, can you please forward. Thnx and Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: simple sql problem

: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

background processes

Hi lists, Can anybody guess the following background processes? ora_s000_ora8 ora_s001_ora8 ora_s002_ora8 ora_p000_ora8 ora_p001_ora8 ora8 is instance. Thnx and Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane

RE: space used by pinned objects

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: simple sql problem

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: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

killing system user

$session. Is there a way to kill this user, without shutting down the database. And why different serial# number each time, I query v$SESSION.? Any clues? Thnx and Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane

total tranx ran

ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: total tranx ran

only the current trnx running. is there any other views that will show the total trnx since instance startup. Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services

RE: Deleting files on w2k

Title: Deleting files on w2k Hi I got this problem many times,when I wokred on win95/98. To resolve this, I used to take the TS offline, shutdown db and windows and restart them and did rename. This worked for me. Srinivas -Original Message-From: Mercadante, Thomas F

RE: total tranx ran

. is there any other views that will show the total trnx since instance startup. Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Not able to view table

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Doubts reg :Export and import

send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Determinants of control file

Title: Determinants of control file Hi Nirmal, Use alter database backup controlfile to trace; You can find these details in the trace file, that will be dumped to your udump destination. HTH Srinivas. -Original Message-From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL

RE: backup unix script

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Analyze only latest partition

, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Virtual NC on Solaris box

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Listener problems

the size of listener.log (There is no parameter for this) is is o/s dependent? Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

aps_data_files

Hi lists, In what way aps_data_files differ from dba_data_file? what this aps_data_files view store in data dictionary? can anybody throw some light? Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED

RE: Repairing corrupt datablocks

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: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

hide password

the password) . I tried it with EOF. But its not working. I need to setup the export in cron. can anybody through some light on this. Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat

RE: hide password

Can you explain in detail how to use a controlfile in exports? thnx and regards, Srinvias -Original Message- Sent: Thursday, November 15, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Hi, Use a controlfile. Jack Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED

RE: hide password

to setup the export in cron. can anybody through some light on this. Thnx and regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: hide password

Deepak --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: But (while performing exp) when we grep from os it will display like ps -ef |grep exp result: exp parfile=/ora8/par1 so, somebody can do a more and find the password from the par1 file. Is there any better

select from dual?

ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: how to find files that are generated on a particular date

10 regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: V$PWFILE_USERS

The v$pwfile_users generates an internal error if the client process fetched from it directly more than once. If only a single fetch is done that retrieves all the rows needed, then it works fine. An order by clause will allow the sort step to fetch all rows in a single call, and then it does

tablespace not turning into read only mode

in that tablespace. But there are users, using someother objects in other tablespaces. why oracle cannot turn the tablespace into read only mode? Thnx and regards srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED

inactive sessions

Hi can anybody tell me when a sessions status becomes INACTIVE in v$session? thnx and regards, srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

column comments for v$ and x$ tables

FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Dead locks

, Shrinivas (MED, Keane) 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

recreate controlfile

datafile system. if not, at least how many minimum of datafiles i need to recreate a controlfile from the backup set.) Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network

RE: Find out export from remote locations

the patch. -Message d'origine- De : Tatireddy, Shrinivas (MED, Keane) [mailto:[EMAIL PROTECTED]] Envoyé : lundi 22 octobre 2001 12:20 À : Multiple recipients of list ORACLE-L Objet : RE: Find out export from remote locations In V$session I am able to find only the session that is connected

RE: Find out export from remote locations

recipients of list ORACLE-L Query the V$session table in Server2. -- On Mon, 22 Oct 2001 00:50:18 Tatireddy, Shrinivas (MED, Keane) wrote: Hi lists, Is there any way to find out if any session is doing export from a remote shell. eg: I am performing this from SERVER1 exp userid=sys/pwd

Transportable tablesapce export on remote server

anybody post me the solution. regards, srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

schema refreshes (transport tablespace)

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

orapwd utility

: Tatireddy, Shrinivas (MED, Keane) 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

RE: Restricted mode

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

date diff at os level

Hi lists can anybody post me this: I need to find out the date at O/s level between 2 dates. i.e. 01-jan-99:10:22:45 and 02-jan-99:09:23:50 O/s : Solaris thnx in adv srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane

RE: export problems in transportable tablespace

of list ORACLE-L The command must be: exp userid=\'system/password@remotelink as sysdba\'.. The sysdba priv has to be after the connection link. Regards. --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists, O/s: Solaris Oracle : 8.1.6 can anybody post

running catlog,catproc

://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

log file size change

. should I use logfile 'file1','file2' size 5 M reuse. ( Note: I use reset logs) regards, srinivas. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Unix Cron Job

://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: Background jobs inUnix

://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

find out ip

Hi lists How to find out a server (solaris) IP address, that I logged in . Any command ? thanx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: find out ip

Thanks a lot -Original Message- Sent: Tuesday, October 02, 2001 5:15 AM To: Multiple recipients of list ORACLE-L $ who am i root pts/12 obre 2 09:11 (192.168.11.33) Regards. --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists How to find out

RE: Background jobs inUnix

this will allow it to run disconnected from a terminal and will continue after you log out. You will get the message you have running jobs when you type exit, just type exit again. --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi Lists, Shall I close the unix session after submitting my

RE: please help me to unlock a table

(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: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services

count rows that are being imported

the total count. Is there anyway to see how may rows imported in that table(in the middle or import process, from another session) ? thnx in adv. srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City

Background jobs inUnix

://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

PL/SQL stment

old value what I previously gave. I need to find out, where my old value is actually stored. and I need it to ask again for another value. where my old value is actually stored? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET

find out the rollback

. If I have this query, at least I will use a rollback segment that has enough extents. thnx in advance. Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

alternative rows

Hi lists can anybody post me to find alternative rows in a table. 1,3,5 ... or 2,4,6 srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

shutdown trigger

) - this stores 3 Are there any possible bugs with shutdown triggers... ? thanx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

octal form

dual, giving some wrong value... how do i convert this octal to decimal srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

insert into table .... values....

), (select colc from dummy3 where ) ); srinivas. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

processes, free mem

: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: FYI - another good Oracle list

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: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

tab ascii value

Hi lists how to find out the ascii value of tab, new line for new line it is 10 for tab it is 9 but how to get from the following statement. select ascii(??) from dual; srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane

pl/sql examples

hi can anybody post me some sites that have example queries of pl/sql thnx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

v$sgastat

how much precision do I take? and is there any way to find from what x$ tables this is (v$sgastat) built . I didnt find it is dependencies table. thnx in advance srinivas. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET

compare two tables.

in advance. srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

any body come across, decreasing db_block_size.

k now that should be decreased to 4K srinvias -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

finding free memory

: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

dyn sql

: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Duplicate rows.

. but this is a lengthy process. any short way? srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

No Subject

UNCUT ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

rollback tables

HI dba's can anybody tell me from which tables can i find whether my statement is generating rollback. post queries if you have.. thnx srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City

is there any way to see when my table data updated?

Hi lists from where can i see when my table data is last updated? srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

avoid duplicate sql

ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: How to locate who dropped a view using log miner?

Title: RE: How to locate who dropped a view using log miner? Hi I dont find any records in v$logmnr_contents even if i dropped tables /views. Should i enable any parameter and restart db to get records. srinivas -Original Message-From: Nick Wagner [mailto:[EMAIL

killing bkground processes

can anybody tell me how to kill the background processes (SNP) that are currently running/sleep mode. alter system kill session is not working. saying user session id does not exist. srinvas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED

divide with decode

this query is returning notthing. i tried with to_number function also, that is not also returning anything. is there any trick to solve this. srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City

part of the table export (incremental?)

the rows, that are newly inserted. is there any way to do such export? thnx in adv srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San