Re[2]: FW: Oracle Enterprise vs Standard
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 support some operations (error SVD> message: this feature is not enabled). SVD> For example: SVD> Fine grained access control, online index rebuild etc. SVD> Thursday, March 13, 2003, 2:43:52 PM, you wrote: ZT>> I need to buy a new Oracle license for 50 users. I have got two different ZT>> quotes for Oracle Enterprise Server and Oracle Standard; it seems the former ZT>> is quite expensive. What problems will I get if I buy the cheaper Standard ZT>> version. This Oracle will be used for BAAN ERP implementation. The ZT>> environment will be IBM RS6000, AIX 5L and a mixture of LAN and WAN clients ZT>> Thanks in advance for you advice ZT>> Regards ZT>> Tapiwa ZT>> -- ZT>> Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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).
Re[2]: Duplicate online Database
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 procedure documented in Oracle CH> Magazine called database cloning that used hot backups and archived logs. I CH> have a white paper on it if you're interested. I'm sure RMAN has the same CH> capability. CH> -- CH> Chuck CH> - Original Message - CH> To: Multiple recipients of list ORACLE-L CH> Sent: Tuesday, March 04, 2003 5:38 AM CH> I need to duplicate online database Oracle 8.1.7. CH> It is not possible to shutdown the primary database. CH> Can I do online backup this primary database by RMAN, CH> and + using archivelogs create duplicate database? CH> Inconsistent backups of RMAN + archivelogs = duplicate database?? CH> Thanks CH> Edouard Dormidontov -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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).
Re[2]: DBV
I ran it. No problem. (Windows 2000 / Oracle 9i) Thanks for all. More information : The problem, four datafile contains corrupt block. (two indexes and two tables). One table I used the package DBMS_REPAIR and made a export, with DIRECT=Y (without it an error happened) and them I imported this 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, 9:34:49 PM, you wrote: JW> I have used DBV repeatedly and heavily on a variety of platforms from JW> version 7.3.2 on. ALthough it has always been called an "Offline JW> Verification Utility," that has never meant that it cannot be used on JW> open datafiles. It just means it is not a utility that connects to JW> the database. JW> DBV has never done anything to datafiles but read. So unless Jack had JW> an OS that writes when you ask it to read, there's no way that DBV JW> could have done anything bad to your database. JW> The 7.3 docs are hilarious. Offline or online >> DB_VERIFY is an external command-line utility that performs a >> physical data structure integrity check on an offline database. It >> can be used against backup files and online files (or pieces of >> files). You use DB_VERIFY primarily when you need to insure that a >> backup database (or datafile) is valid before it is restored or as a >> diagnostic aid when you have encountered data corruption problems. JW> -- JW> Jeremiah Wilton JW> http://www.speakeasy.net/~jwilton JW> On Wed, 26 Feb 2003, Daniel W. Fink wrote: >> I had a scheduled job that ran dbv on Solaris 8.0.4 databases once a >> week. Never a problem. It has been awhile since I used it on Windows, >> and I don't recall using it on 7.3 (not that I did not, but my memory is >> starting to go...). I have never had a problem with it, either with the >> db up or down. >> From the 8i Data Server Internals (which I have found accurate) >> "DBVERIFY Utility...Opens data files read-only; can run while the >> database is open." >> >> dbverify was introduced in 7.3, so you could have encountered a bug. It >> is definitely a good idea to try it out first on a test database. >> >> Dan Fink >> >> [EMAIL PROTECTED] wrote: >> >> >Dan, >> > >> >That must be new for 9i, since my 8.1.7 docs say it is an "offline" >> >utility. I remember hosing an entire 7.3 test database years ago when I >> >first ran DBV on it while it was up and open - can't remember the errors, >> >but the DB was unusable. One of the (too) many times I learned to read the >> >docs more carefully. :-( >> > >> >Jack C. Applewhite >> >Database Administrator >> >Austin Independent School District >> >Austin, Texas >> >512.414.9715 (wk) >> >512.935.5929 (pager) >> >[EMAIL PROTECTED] >> > >> > >> > >> > >> > >> > "Daniel W. Fink" >> > >> > <[EMAIL PROTECTED]To: Multiple recipients of >> > list ORACLE-L >> > .com> <[EMAIL PROTECTED]> >> > >> > Sent by: cc: >> > >> > [EMAIL PROTECTED] Subject: Re: DBV >> > >> > >> > >> > >> > >> > 02/26/2003 01:54 >> > >> > PM >> > >> > Please respond to >> > >> > ORACLE-L >> > >> >
DBV - New Info
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://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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).
DBV
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. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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).
Re: Service startup on Windows 2000 fails
Lisa, I'm using Windows 2000 with Oracle DataBase 9i. And I had a similar problem with you afer install the database. The Listener service does not show in the list of Windows services. Try stop the listener and restart it. Use the application "LSNRCTL" at Commaand Prompt Type "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, ver 8.1.7.2 KL> I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, KL> nothing. KL> Here's what I've tried: KL> Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. KL> All logons are part of the administrator and the ORA_DBA group. KL> I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. KL> Local system account also fails with same error. KL> Here's the error I receive when I try to manually start the listener service: KL> "Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the KL> problem persists, contact your system administrator." KL> I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. KL> Any suggestions would be helpful. Thanks KL> Lisa Koivu KL> Oracle Database Administrator KL> Fairfield Resorts, Inc. KL> 5259 Coconut Creek Parkway KL> Ft. Lauderdale, FL, USA 33063 KL> Office: 954-935-4117 KL> Fax: 954-935-3639 KL> Cell: 954-683-4459 KL> -- KL> Please see the official ORACLE-L FAQ: http://www.orafaq.net KL> -- KL> Author: Koivu, Lisa KL> INET: [EMAIL PROTECTED] KL> Fat City Network Services-- 858-538-5051 http://www.fatcity.com KL> San Diego, California-- Mailing list and web hosting services KL> - KL> To REMOVE yourself from this mailing list, send an E-Mail message KL> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in KL> the message BODY, include a line containing: UNSUB ORACLE-L KL> (or the name of mailing list you want to be removed from). You may KL> also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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).
Question About RMAN
Hi, I'm planning work with this aplication(RMAN). I think that everybody agree with me after many questions in this group. Today, my database are in Archive mode and I make manually the copy of datafiles. And I run the export utility too. About RMAN. If I want to recover only a table ? Can 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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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).
Re: Skipping a table on import
Craig, you can export a owner without a table. See the note : How to Export a Database Bypassing a Table in Oracle7 and Oracle8 at metalink. If you don't have access to metalink send a email to me. But don't have any way to import Bypassing a table. I asked it to Oracle Suport at metalink 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 of data and it's taking hours. Is there a way to skip CH> certain tables during an import? CH> We're using 8.1.7 CH> We have 400 tables, so I'd like to avoid having to list all the tables CH> in the export statement. CH> I have to pre-create the tables to put them in the correct tablespace, CH> so could I alter the table definitions to force import to skip CH> particular ones? CH> Any help is appreciated. CH> Craig Healey CH> ** CH> This email and any files transmitted with it are confidential and intended solely CH> for the use of the individual or entity to whom they are addressed and may contain CH> confidential and/or privileged material. Any review, retransmission, dissemination CH> or other use of, or taking of any action in reliance upon, this information by CH> persons or entities other than the intended recipient is prohibited. Statements CH> and opinions expressed in this e-mail may not represent those of the company. CH> If you have received this email in error please notify [EMAIL PROTECTED] CH> This footnote also confirms that this email message has been swept by MIMEsweeper CH> for the presence of computer viruses (www.mimesweeper.com) CH> *************** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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).
Re[2]: Update NT to 2000 Server
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 wrote: HS> First off I am an NT/Win2k admin and I fully agree with you Jared. Blow the HS> partition and start from zero, you'll be happy you did. HS> Scott HS> First off, I am not an NT/Win2k admin, and don't even play one on TV. HS> The advice from every SA I've asked about this, and from searching the HS> web, HS> is don't do it. Rebuild the box. There are remnants of NT left if you do HS> an HS> upgrade, and you don't really want that, do you? HS> Jared HS> "Breno A. K. Magnago" <[EMAIL PROTECTED]> HS> Sent by: [EMAIL PROTECTED] HS> 02/06/2003 08:54 AM HS> Please respond to ORACLE-L HS> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> HS> cc: HS> Subject:Update NT to 2000 Server HS> Hello, HS> I'd like to update my server (Windows NT) to Windows 2000 Server. HS> I have a Oracle Database 9i in this machine. HS> Does anyone know any kind of problem in this operation (database HS> compatible) ? HS> Thank. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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).
Update NT to 2000 Server
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 Soares -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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).
Re[4]: undo tablespace
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. Magnagomailto:[EMAIL PROTECTED] Wednesday, January 29, 2003, 2:04:39 PM, you wrote: HMNI> You're correct in saying that your undo blocks are protected by your redo HMNI> files. HMNI> What type of operation are you performing on your table? I ask because only HMNI> a small subset of commands support the NOLOGGING feature; the remainder will HMNI> generate redo as usual. HMNI> If you're not using a syntax that supports NOLOGGING maybe you could adapt HMNI> your job to adopt one. HMNI> Alternatively you may find that you just need to optimise your redo log HMNI> placement in order to handle the load. HMNI> Regards, HMNI> Mike Hately HMNI> -Original Message- HMNI> Sent: 29 January 2003 14:10 HMNI> To: Multiple recipients of list ORACLE-L HMNI> Mike, HMNI> I asked it because I have a problem. HMNI> Any insert data in UNDO tablespace generate insert in REDO Files. Is HMNI> is correct ? HMNI> When I execute a high procedure, many inserts in UNDO tablespace HMNI> ocurres, so many inserts in REDO´s are genereate. HMNI> I want to avoid this REDO´s generation. HMNI> My tables and indexes are in NOLOGGING, but I high value of HMNI> REDO are generate (100 MB each 20 minutes). It is desnecessary. HMNI> Oracle 9i / NT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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).
Re[4]: undo tablespace
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, you wrote: FD> Breno, FD> 100mb of redo in 20 minutes is not all that high. I have seen far FD> worse (as I am sure most on the list have as well). Why do you perceive this FD> as a problem? Are you seeing poor performance or waits? FD> Is the generation of redo (and archived logs) causing the system to FD> halt due to the archive_dump_dest filling up? If so, the problem is not the FD> procedure, but rather the lack of proper process to manage your archive FD> logs. FD> Even with NOLOGGING, UNDO must be generated for read consistency, FD> rollback and recovery. You are not inserting data into the undo tablespace. FD> The undo entries are generated for each operation (insert/update/delete). FD> However, the undo entry for an insert is very small and thus will consume FD> very little undo space and redo. FD> Don't concern yourself with trying to stop the generation of UNDO. FD> You will end up causing yourself more problems that you will ever try to FD> solve. It is part of the Oracle kernel and not modifiable (at least in this FD> release). Focus on performance and decide if 100mb in 20 minutes is really a FD> problem. FD> Dan Fink FD> -Original Message- FD> Sent: Wednesday, January 29, 2003 7:10 AM FD> To: Multiple recipients of list ORACLE-L FD> Mike, FD> I asked it because I have a problem. FD> Any insert data in UNDO tablespace generate insert in REDO Files. Is FD> is correct ? FD> When I execute a high procedure, many inserts in UNDO tablespace FD> ocurres, so many inserts in REDO´s are genereate. FD> I want to avoid this REDO´s generation. FD> My tables and indexes are in NOLOGGING, but I high value of FD> REDO are generate (100 MB each 20 minutes). It is desnecessary. FD> Oracle 9i / NT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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).
Re[2]: undo tablespace
Mike, I asked it because I have a problem. Any insert data in UNDO tablespace generate insert in REDO Files. Is is correct ? When I execute a high procedure, many inserts in UNDO tablespace ocurres, so many inserts in REDO´s are genereate. I want to avoid this REDO´s generation. My tables and 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> Breno, HMNI> There's no way to do this because it's the central pillar of Oracle's read HMNI> consistency mechanism. HMNI> It's possible to minimise or suppress redo but undo is out of your control. HMNI> regards, HMNI> Mike Hately HMNI> -Original Message- HMNI> Sent: 29 January 2003 11:39 HMNI> To: Multiple recipients of list ORACLE-L HMNI> I have a high procedure (many INSERT's and UPDATE´s). HMNI> This procedure generate insert's in UNDO TableSpace for rollback. HMNI> I want to know if exists any way for don´t generate insert´s in UNDO HMNI> Tablespace. HMNI> Oracle 9i / NT HMNI> Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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).
undo tablespace
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] Mercantil de Alimentos Soares -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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).
"Imp.exe" and "Exp.exe"
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 A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 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).
Re: help how get the n top rows for any table?
Alexander, Tuesday, July 10, 2001, 1:45:51 PM, you wrote: AO> Hi, gurus!!! AO> A need know how get n top row for any table somebody can help me!! AO> Thanks!!! AO> @lex AO> AO> Lic. Alexander Ordóñez Arroyo AO> Caja Costarricense del Seguro Social AO> Soporte Técnico - División de Informática AO> Telefono: 295-2004, San José, Costa Rica AO> [EMAIL PROTECTED] AO> 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:[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 FAX: (858) 538-5051 San Diego, California-- 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 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).
ORA-0313
ORACLE-L, In SQL PLUS, I had this problem when I tried delele a table, " delete linha_prodt; delete linha_prodt * ERROR at line 1: ORA-03113: end-of-file on communication channel " for solve this, I droped the table, but the problem ocurred again. I had this problem only in this table 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 FAX: (858) 538-5051 San Diego, California-- 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 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).
