RE: Which rollback segment is currently active?

2003-02-05 Thread Bernardus Deddy Hoeydiono
can drop that rollback segment. alter rollback segment rollback_segment_name offline; alter rollback segment rollback_segment_name drop; Thank's Bernardus Deddy Hoeydiono. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Nguyen, David MSent

RE: Windows 2000 Cluster on oracle

2003-02-05 Thread Bernardus Deddy Hoeydiono
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: Bernardus Deddy Hoeydiono INET: [EMAIL PROTECTED] Fat City

RE: Windows 2000 Cluster on oracle

2003-02-05 Thread Bernardus Deddy Hoeydiono
upto you if you're sure that your Windows is OK. But, You have to carefull with the service pack in Windows 2K. I suggest if your O/S (Win2K) running well ,please don't apply the service if not necessary. BTW, What kind of server that you used and spec of the server ? Thank's Bernardus Deddy

RE: temp space

2003-01-19 Thread Bernardus Deddy Hoeydiono
create the table, the temporary tablespace will follow the temporay tablespace that already assign in the user creation. To solve this problem, please resize the teporary tablespace. Thank's Bernardus Deddy Hoeydiono. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Setting profile limits?

2003-01-09 Thread Bernardus Deddy Hoeydiono
userusername profile profile_name; After you finish all the things above, you can test. And I believe it's working, becuase I have used before. Thanks, Bernardus Deddy Hoeydiono. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Denham EvaSent: Thursday

RE: Performance Issue on 817 !!!

2003-01-08 Thread Bernardus Deddy Hoeydiono
Hi Jackson Dumas, Have check the virtual memory (paging space) of the OS ? Because sometimes it's related. And, how big memory that you used in your server ? Thank's Bernardus Deddy Hoeydiono. -Original Message- Dumas Sent: Wednesday, January 08, 2003 2:59 PM To: Multiple recipients

RE: Delete duplicate records

2003-01-08 Thread Bernardus Deddy Hoeydiono
having count(ean)1) and varutyp =3; regards, Bernardus Deddy Hoeydiono. -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 3:24 PM To: Multiple recipients of list ORACLE-L Hallo, I have this sql, SELECT * FROM varukorgtmp where varukorgid= 120 That makes

RE: Truncate system tables.

2003-01-08 Thread Bernardus Deddy Hoeydiono
file is valid 100%. 3. run the script catalog.sql from directory $ORACLE_HOME/rdbms/admin 3. recreate the application user and import the export file. I hope this solution can help you. Thank's Bernardus Deddy Hoeydiono. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: invalid procedure/trigger

2003-01-08 Thread Bernardus Deddy Hoeydiono
into the scheduller which running every night. Thank's Bernardus Deddy Hoeydiono. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of shuan.tay(PCI¾G¸R³Ô)Sent: Thursday, January 09, 2003 9:59 AMTo: Multiple recipients of list ORACLE-LSubject: invalid