RE: Waking SMON Not Doing Trick

- 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

Re: Script for checking temp usage

ing > temp and how much they are using? We occasionally get runaway sessions that > don't release temp and this would allow us to easily locate the offending > session. > > I've already checked OraMag and used google with no significant results. > > Thanks in advanc

RE: export user definitions

what kind of options you use in 'strings' command? There is one option like 'strings -a | -'. When I tried this option on dump file, it didn't work. Thanks in advance! Lucy Lin On Mon, 10 Sep 2001, Deshpande, Kirti wrote: > Rajesh, > I am afraid inde

Re: import fails with referentail integrity constraint violation

always try to import t_acc_usage before the t_usage as i alphabetical > order and the > import for this table always fails as t_usage is primary table..referntial > integrity problem.. > how to resolve this issue. > > Thanks > -Harvinder > -- Lucy Lin Oracle D

Re: How do I control NEXT parameter in the table....

yone tell me > how do I resolve this problem by not adding new datafile.. > > Thanks in advance > Uday > > -- Lucy Lin Oracle DBA condenet.com 212-286-3852 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lucy Lin INET: [EMAIL PROTECTED] Fat City

Re: how to rename a database SID

just recreate database control file. On Mon, 18 Jun 2001, Andrey Bronfin wrote: > HI ! > How can i rename a database on NT / UNIX ? > Thanks a lot in advance ! > -- Lucy Lin Oracle DBA condenet.com 212-286-3852 -- Please see the official ORACLE-L FAQ: http://www.orafaq.co

Re: BACKUP CONTROLFILE TRACE

own the db and removed the existing controlfiles from the > oracle directory. > > Now, how can i create the control files from the backup trace file. > > Please help me. > > Regards, > Nirmal > -- Lucy Lin Oracle DBA condenet.com 212-286-3852 -- Please see the offici

Re: OT Unix shell variable question

to administer the Coup de Grâce via your Ninja > Death Touch, you step on a beer bottle and fall backwards into the juke box > and get your head stove in by a drunk with a pool cue." --Jay Trigg > > -- Lucy Lin Oracle DBA condenet.com 212-286-3852 -- Please see the official O

Re: Truncate listener.log how?

.log listener.old > tail -10 >listener.log > Thanks in advance. > -seema > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- Lucy Lin Oracle DBA condenet.com 212-286-

RE: username

;SERIAL# > -- > FORMS dervid 80 > 60008 > > my question is why the username from v$sort_usage is different from the > one from v$session. I thought they should be the same. > > Any idea is welcome

Re: What columns are in the Primary Key

in the primary key "PK_ACCOUNTS" ? I have > more NOT NULL columns in the table than in the PK. > > Any idea? > > This is 8.1.6 on Win2k. > > Thanks, > Helmut > > -- Lucy Lin Oracle DBA condenet.com 212-286-3852 -- Please see the official ORACLE-L FAQ

username

age is different from the one from v$session. I thought they should be the same. Any idea is welcome. Thanks in advance! -- Lucy Lin Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lucy Lin INET: [EMAIL PROTECTED] Fat City Network Services-- (85