How can I get my DB back if I lost one of my rollback segment (rb

2001-08-14 Thread Hermanto P
: Hermanto P 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

RE: How can I get my DB back if I lost one of my rollback segment

2001-08-14 Thread Hermanto P
/cybprod/rbs02.dbf' ORA-01207: file is more recent than control file - old control file Warm Regards, Hermanto P Application Engineer PT Riau Andalan Pulp And Paper - IT/IS Dept. Phone : (0761) - 491147 / 491354 HP: 0812-752-3092 Dream as if you'll live forever, live as if you'll die today

How to find exact value to resize a datafile

2001-08-08 Thread Hermanto P
the solution like this : - find out the next extent for the segment. select next_extent from dba_segments - resize it. Any comments or correction about this ?? Thanks for your advise. Warm Regards, Hermanto P Application Engineer PT Riau Andalan Pulp And Paper - IT/IS Dept. Phone

RE: SGA info.

2001-08-08 Thread Hermanto P
selected. SVRMGR Warm Regards, Hermanto P Application Engineer PT Riau Andalan Pulp And Paper - IT/IS Dept. Phone : (0761) - 491147 / 491354 HP: 0812-752-3092 Dream as if you'll live forever, live as if you'll die today -Original Message- Sent: Thursday, August 09, 2001 11:30 AM

RE: extent management

2001-07-12 Thread Hermanto P
Thanks Suher, it works !! Warm Regards, Hermanto P Application Engineer PT Riau Andalan Pulp And Paper - IT/IS Dept. Phone : (0761) - 95529 Ext. 1147 - 1266 HP : 0812-752-3092 Our greatest glory is not in never falling but in rising every time we fall -Original Message- Sent

extent management

2001-07-11 Thread Hermanto P
manage the extent of table ? What I have to do if I have reach 121 maxextents value ? Thanks before for your kind advise. Warm Regards, Hermanto P Application Engineer PT Riau Andalan Pulp And Paper - IT/IS Dept. Phone : (0761) - 95529 Ext. 1147 - 1266 HP : 0812-752-3092 Our greatest glory

RE:

2001-06-19 Thread Hermanto P
database ??? Dear Hermanto, more details would really help... -- From: Hermanto P[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 12:40 PM To: Multiple recipients of list ORACLE-L Dear Subscribers, I have a broken database

RE:

2001-06-19 Thread Hermanto P
help me how to recover ? m-t-x Our greatest glory is not in never falling but in rising every time we fall -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hermanto P INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

No Subject

2001-06-18 Thread Hermanto P
-- Author: Hermanto P 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