Re[2]: FW: Oracle Enterprise vs Standard

2003-03-13 Thread Breno A. K. Magnago
Sergey, after, you can upgrade from standard to enterprise. -- Breno A. K. Magnagomailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares Thursday, March 13, 2003, 7:19:03 AM, you wrote: SVD> Hello Tapiwanashe, SVD> Oracle Standard edition does not suppor

Re[2]: Duplicate online Database

2003-03-06 Thread Breno A. K. Magnago
Chuck, I'm inserested in this paper. Can you send it to me ? Thanks. -- Breno A. K. Magnagomailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares Tuesday, March 04, 2003, 11:03:43 AM, you wrote: CH> I don't see why not. Prior to RMAN I used a procedu

Re[2]: DBV

2003-02-27 Thread Breno A. K. Magnago
table. I lost only 8 rows with this procedure. For the other table I will make the same. About the index, I will recreate it. My online backup is corrupted too. -- Breno A. K. Magnagomailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares Wednesday, February 26, 2003

DBV - New Info

2003-02-26 Thread Breno A. K. Magnago
Hi, Can I use the program DBV on a production datafile (read and write), without take offline the tablespace ? New Info : Windows 2000 Oracle 9.0.1.1.1 -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares -- Please see the official ORACLE-L FAQ: http

DBV

2003-02-26 Thread Breno A. K. Magnago
Hi, Can I use the program DBV on a production datafile (read and write), without take offline the tablespace ? -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K

Re: Service startup on Windows 2000 fails

2003-02-20 Thread Breno A. K. Magnago
"STOP" and them "START". -- Breno A. K. Magnagomailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares Wednesday, February 19, 2003, 11:08:53 AM, you wrote: KL> Service startup on Windows 2000 failsGood morning everyone, KL> Windows 2000 sp3

Question About RMAN

2003-02-12 Thread Breno A. K. Magnago
I do it ? It´s very easy to do using a export file. And about using RMAN application ? Thanks -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [

Re: Skipping a table on import

2003-02-07 Thread Breno A. K. Magnago
talink and he answered it. -- Breno A. K. Magnagomailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares Friday, February 07, 2003, 8:04:08 AM, you wrote: CH> Hi, CH> I'm trying to import the live schema into a test schema, but 1 or 2 CH> tables have a lot

Re[2]: Update NT to 2000 Server

2003-02-06 Thread Breno A. K. Magnago
OK. And about the Oracle compatible. Only create a new windows 2000 service is necessary, any upgrade of database is require. Is it Correct ? -- Breno A. K. Magnagomailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares Thursday, February 06, 2003, 4:39:17 PM, you

Update NT to 2000 Server

2003-02-06 Thread Breno A. K. Magnago
Hello, I'd like to update my server (Windows NT) to Windows 2000 Server. I have a Oracle Database 9i in this machine. Does anyone know any kind of problem in this operation (database compatible) ? Thank. -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos S

Re[4]: undo tablespace

2003-01-29 Thread Breno A. K. Magnago
Mike, What type of operation are you performing on your table? INSERT INTO A.TABLE1(COL1,COL2) SELECT COL1,COL2 FROM B.TABLE2@DB_LINK; I think that command support the NOLOGGING.Is is correct ? The table B.TABLE2 and all indexes are in NOLOGGING Option. -- Breno A. K. Magnago

Re[4]: undo tablespace

2003-01-29 Thread Breno A. K. Magnago
Dan, Is the generation of redo (and archived logs) causing the system to halt due to the archive_dump_dest filling up? YES I'll work to minimize this situation. Thanks. -- Breno A. K. Magnagomailto:[EMAIL PROTECTED] Wednesday, January 29, 2003, 1:19:50 PM

Re[2]: undo tablespace

2003-01-29 Thread Breno A. K. Magnago
indexes are in NOLOGGING, but I high value of REDO are generate (100 MB each 20 minutes). It is desnecessary. Oracle 9i / NT -- Breno A. K. Magnagomailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares Wednesday, January 29, 2003, 10:29:15 AM, you wrote: HMNI> Br

undo tablespace

2003-01-29 Thread Breno A. K. Magnago
I have a high procedure (many INSERT's and UPDATE´s). This procedure generate insert's in UNDO TableSpace for rollback. I want to know if exists any way for don´t generate insert´s in UNDO Tablespace. Oracle 9i / NT Thanks. -- Breno A. K. Magnago mailto:[EMAIL PROTECTED]

"Imp.exe" and "Exp.exe"

2003-01-17 Thread Breno A. K. Magnago
I need two files (Imp.exe and exp.exe) for Oracle 8.1.5 on Windows NT 4.0. If someone have. Please send for me. Thanks. -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno

Re: help how get the n top rows for any table?

2001-07-10 Thread Breno A. K. Magnago
--- AO> UNIX is very user friendly, AO> It's just very particular about who it makes friends with. Example with ROWNUM : SELECT COD FROM DETAIL WHERE ROWNUM < 5 ORDER BY COD DESC This script gets 4 tops rows -- Breno A. K. Magnagomailto:

ORA-0313

2001-05-03 Thread Breno A. K. Magnago
ble at the database.Why ? -- Thanks, Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051