RE: standby database configuration in 9iR2 SE ?
Standby is only for Enterprise Ed. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Prem Khanna J Enviado el: martes, 16 de diciembre de 2003 8:24 Para: Multiple recipients of list ORACLE-L Asunto: standby database configuration in 9iR2 SE ? List, Can someone give me a doc/URL for the steps invloved in standby database configuration ( manual recovery mode ) on 9iR2 SE ? I do have a doc for standby database configuration ( managed recovery mode ) for 8i EE . except automatic log transfer which is not a feature of SE , will the steps involved be quite different or almost the same ? Your suggestions please . Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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: RedHat Advanced Server v3.0, anyone?
I am sorry. De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de [EMAIL PROTECTED]Enviado el: martes, 16 de diciembre de 2003 0:34Para: Multiple recipients of list ORACLE-LAsunto: RE: RedHat Advanced Server v3.0, anyone? MetaLink is an official Oracle support mechanism for paid subscribers. Please be careful about cutting and pasting documentation from MetaLink into a mailing list. Quoting parts of a MetaLink document may be OK. Please do not quote entire articles, and *especially* do not cut and paste forum articles, partiularly with the names of the of posters. I haven't been contacted by an Oracle attorney in a while now, and am looking forward to mantaining the status quo. Jared ( List Owner) "Juan Miranda" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/15/2003 01:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: RedHat Advanced Server v3.0, anyone? I have a system with RH AS 2.1 in production and is very very fast and reliable. The server is a Proliant with 8GB RAM and 2x Intel Xeon. Oracle installation was easy, only take care if you have big memory. Also remenber to update the kernel. The predetermined don´t let start database. I tried RH AS 3 and Oracle installation and there are a lot of problems. It´s nearly almost essential to read this http://www.puschitz.com/InstallingOracle9i.shtml. Anyway I think RH is a good S.O. Look at Metalink: Unix Installation/OS: RDBMS Technical Forum Displayed below are the messages of the selected thread. Thread Status: Active From: ...RDBMS Version: 9.2.0.1.0Operating System and Version: Red Hat Enterprise Linux 3.0 ESError Number (if applicable): Product (i.e. SQL*Loader, Import, etc.): Product Version: . De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Paul DrakeEnviado el: viernes, 12 de diciembre de 2003 23:24Para: Multiple recipients of list ORACLE-LAsunto: RedHat Advanced Server v3.0, anyone? Has anyone kicked the tires on RH AS 3.0? There is a strong possibility that in a migration early next year, that a client wants to move off of MS w2k adv svr and onto either RH AS or SLES (they are an HP (compaq) shop). It seems like a bad idea to start them off on RH AS 2.1 now, when they likely won't take the system into production until after close of the first quarter. thanks, Paul Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing ATT00016.gifATT00019.gifATT00022.gifATT00025.gifATT00028.gif
RE: RedHat Advanced Server v3.0, anyone?
I have a system with RH AS 2.1 in production and is very very fast and reliable. The server is a Proliant with 8GB RAM and 2x Intel Xeon. Oracle installation was easy, only take care if you have big memory. Also remenber toupdate the kernel. The predetermined don´t let start database. I tried RH AS 3 and Oracle installation and there are a lot of problems. It´s nearly almost essential to read this http://www.puschitz.com/InstallingOracle9i.shtml. Anyway I think RH is a good S.O. Look at Metalink: Unix Installation/OS: RDBMS Technical Forum Displayed below are the messages of the selected thread. Thread Status: Active From: WILLIAM BECKER 06-Nov-03 16:46 Subject: Install 9.2 on Red Hat Enterprise Linux 3.0 RDBMS Version: 9.2.0.1.0Operating System and Version: Red Hat Enterprise Linux 3.0 ESError Number (if applicable): Product (i.e. SQL*Loader, Import, etc.): Product Version: Install 9.2 on Red Hat Enterprise Linux 3.0I am compiling an install plan for Oracle Standard Edition 9.2.0.1 on Red Hat Enterprise Linux 3.0 ES. I have read note 252217.1 and have the following plan: (Assume no issues with rpms, shmmax, swap, /tmp, binutils, accounts, groups, env. settings, gcc and g++ are relinked) 1) Apply patch 3006854 before running runInstaller 2) Install software only from CD - do not create database 3) Apply patch 3095277_9204 to update Universal Installer 4) Apply patch 3095277_9204 a second time to update Oracle software to 9.2.0.4 5) Apply patch 2617419 to install opatch 2.2, needed to apply next patch 6) Apply patch 3119415 using opatch - make sure "fuser" utility is in path of account doing the install 7) Apply patch 3208258 to use asynch_io Questions: 1) Are the above steps correct? Am I missing anything? 2) I have not been able to locate patch 3208258 on metalink; how can I locate and download it? 3) Are there any major differences in the above steps when installing Oracle Enterprise Edition 9.2 on Red Hat Enterprise Linux 3.0 AS? Thanks. From: Jason Dravet 19-Nov-03 00:56 Subject: Re : Install 9.2 on Red Hat Enterprise Linux 3.0 I would like the answer to this as well. I am planning on installing oracle 9.2 on RHEL3 on Tuesday the 25th. I am getting RHEL3 ready for the install now, installing the RPMS, accounts, downloading all of the oracle patches, etc. It would be really nice if oracle were to release a 9.3 that had all of the patches preinstalled and use the latest gcc so we don't need the compat libraries. This would make DBA and sysadmin lives easier. Jason Dravet [EMAIL PROTECTED] From: Oracle, somdyuti paul 19-Nov-03 19:37 Subject: Re : Install 9.2 on Red Hat Enterprise Linux 3.0 Hi, The steps told by William are correct. For further clarifications one can go to Metalink-Certify and Availability and can select additional information on certification of 9.2.0.1 on RH 3.0 ES. There is no difference between installation of Oracle Enterprise Edition 9.2 on Red Hat Enterprise Linux 3.0 AS and 3.0 ES,both are certified. I don't think that you need to apply the patch 3208258 to use asynch_io because the above is a bug reported in 9.2.0.4 and fixed in 9.2.0.4.But incase you face any problem apply the 9.2.0.4 patchset. Regards, Somdyuti Oracle , Somdyuti De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Paul DrakeEnviado el: viernes, 12 de diciembre de 2003 23:24Para: Multiple recipients of list ORACLE-LAsunto: RedHat Advanced Server v3.0, anyone? Has anyone kicked the tires on RH AS 3.0? There is a strong possibility that in a migration early next year, that a client wants to move off of MS w2k adv svr and onto either RH AS or SLES (they are an HP (compaq) shop). It seems like a bad idea to start them off on RH AS 2.1 now, when they likely won't take the system into production until after close of the first quarter. thanks, Paul Do you Yahoo!?New Yahoo! Photos - easier uploading and sharing forum_select.gifThe previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. forum_postnew2.gifThe previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for
RE: Re: Logical StandBy question
I am just planning a LOGICAL data guard installation in an important client. They need it for reporting and backup (primary is 24x7x365 and we have hot backup.) I didnt kwon that LSB are so bad. So do you think It is so bad that you dont put it into production ??? Do you try 9.2.0.4 ?? I need to take a decision I thankyour previous answers. (I read doc, of course, but It is not explicity say that) -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]En nombre de Carel-Jan EngelEnviado el: mircoles, 12 de noviembre de 2003 19:59Para: Multiple recipients of list ORACLE-LAsunto: RE: Re: Logical StandBy questionWalt, drop me your email-address, and I send you the handouts of a special I presented about DG for Oracle University in Stockholm.I'm going out now for a few hours (it's 19.30 over here), but I'll respond later this evening.regards, Carel-JanAt 09:19 12-11-03 -0800, you wrote: Stephane,What sort of problems can one expect from logical standby?I'm toying with the idea of using it as a replication database -- noadditional schema objects will be created, but users will have read-onlyaccess to it. It's one of the options I'm looking at.Seems to me like there was a thread on this a few months ago, but I'mnot sure...--WaltOn Wed, 2003-11-12 at 09:49, Stephane Faroult wrote: Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. --Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Walt Weaver INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). DBA!ert, Independent Oracle Consultancy Kastanjelaan 61C2743 BX WaddinxveenThe Netherlandstel. +31 (0) 182 640 428fax +31 (0) 182 640 429mobile+31 (0) 653 911 950e-mail [EMAIL PROTECTED]
Logical StandBy question
Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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: Memory consumption on HP-UX
Take care with automatic PGA management. We have TNS12500 HPUX err 12 using it because proceses RESERVING lots of swap. We change to manual PGA (we use sort_area_size, etc.) It was on 9.2.0.1 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Richard Foote Enviado el: martes, 11 de noviembre de 2003 13:35 Para: Multiple recipients of list ORACLE-L Asunto: Re: Memory consumption on HP-UX Hi Helmut, Notice the parameter is called pga_aggregate_TARGET and not pga_aggregate_MAX_SIZE. That's because the P_A_T is just that, a target the Oracle does it's best to not exceed. It does this by controlling and rationing the tuneable component of the PGA (ie. those portions of the PGA previously controlled by the *_AREA_SIZE parameters) on a as need/on demand basis based on current system load. However, if the number of sessions/processes is such that the other non-tuneable components of the PGAs were to put pressure on the P_A_T, then Oracle may have no choice but to exceed it. This is not a good thing in that obviously more PGA memory is allocated that you ideally want and also because the workarea operations are not going to be the ideal optimal executions you're after. Increasing the P_A_T would be therefore be recommended, depending of course on your available memory. v$pgastat, v$pga_target_advice and v$process will give you useful info on how much you may have exceeded your P_A_T. Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 7:54 PM Hi, how do I find out how much memory Oracle uses on an HP-UX box? Finding the shared memory portion (i.e. SGA) is fairly easy... But how do I find out how much memory each dedicated user process is consuming? Or is the rule of thumb like this: no matter whether you have 10 or 500 users, the memory consumed by the user processes will never exceed pg_aggregate_target? This would mean that the maximum memory consumption is SGA + PGA_AGGREGATE_TARGET. No matter how many users are on the system (of course you would size PGA_aggregate_target accordingly beforehand). This is 9.2 on HP-UX 11. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daiminger, Helmut 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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).
Where can I download 10g ?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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: How do we know that an index need to be rebuilt.
set serveroutput on size 100
set pagesize 0
set feedback off
set echo off
set trimspool on
spool c:\reb_index1.sql
DECLARE
dbname varchar2(20);
wdayvarchar2(11);
BEGIN
dbms_output.put_line('set echo off');
dbms_output.put_line('set feedback off');
dbms_output.put_line('set head off');
dbms_output.put_line('spool c:\reb_index2.sql');
dbms_output.put_line('prompt set feedback on');
dbms_output.put_line('prompt set echo on');
dbms_output.put_line('prompt spool c:\reb_index2.log');
FOR t IN (select owner, index_name from dba_indexes where owner not in
('SYS','SYSTEM') order by owner,index_name) LOOP
dbms_output.put_line('prompt --Analizando
'||t.owner||'.'||t.index_name);
dbms_output.put_line('Analyze index '||t.owner||'.'||t.index_name||'
validate structure;');
dbms_output.put_line('select ' || || 'Alter index ' || t.owner ||
'.' || t.index_name || ' rebuild online;' || || ' from index_stats where
(height 2) or
(10=decode(lf_rows_len,0,NULL,((del_lf_rows_len/lf_rows_len)*100)));');
END LOOP;
dbms_output.put_line('prompt spool off');
dbms_output.put_line('spool off');
dbms_output.put_line('@c:\reb_index2.sql');
END;
/
spool off
[EMAIL PROTECTED]:\reb_index1.sql
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de
Veeraraju_Mareddi
Enviado el: lunes, 22 de septiembre de 2003 8:00
Para: Multiple recipients of list ORACLE-L
Asunto: How do we know that an index need to be rebuilt.
Dear Friends,
Can somebody tell me how do we that an index needs to be rebuilt.. Different
scenarios / any documents will be helpful.
Thanks in advance.
Rajuvera
**
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or
distribution or forwarding of any or all of the contents in this message is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Veeraraju_Mareddi
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Juan Miranda
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).
Anyone have a copy of DUL ??
There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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: Anyone have a copy of DUL ??
I do it but there say don´t have DUL -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Tanel Poder Enviado el: jueves, 18 de septiembre de 2003 15:50 Para: Multiple recipients of list ORACLE-L Asunto: Re: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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).
How to extract data directly from a datafile ?
We need to extract the data of a datafile directly, because we don´t have the rest of the database (other tablespaces, controlfile, etc). Are there some utility like DUL ? What about Unicenter Fast Unload ?. Works it with the datafile directly ? Does it need the database open ? thanks
RE: ocp discount
put OTN20 in the discount code -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]En nombre de AKEnviado el: martes, 27 de mayo de 2003 18:45Para: Multiple recipients of list ORACLE-LAsunto: ocp discount I heard/read they give 20% discount on ocp exam fee if u are registered with technet . Can any body confirm that . How do I get that discount ? -ak
RE: hw info on Tru64 system
Look for sys_check.tar in the Compaq web. It do a full test and audit of your system. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de DENNIS WILLIAMS Enviado el: jueves, 06 de febrero de 2003 15:59 Para: Multiple recipients of list ORACLE-L Asunto: RE: hw info on Tru64 system Vladimir - Quick answer, look in the message file that was created the last time the system was booted up. There is also a command you can enter, I just don't know what it is. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 06, 2003 4:57 AM To: Multiple recipients of list ORACLE-L Good day to everyone How do I find hardware info on Tru64 machine? Available RAM, number of CPUs...? Thanks in advance, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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: OT - Raid
-Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Mark Leith Enviado el: martes, 28 de enero de 2003 15:34 Para: Multiple recipients of list ORACLE-L Asunto: OT - Raid Hi All, Does anybody have any good resources that discuss the pros and cons of each RAID level, and their respective set up procedures? Thanks in advance for any pointers. Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith 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). Raid1.zip Description: Zip compressed data
RE: Oracle 9.2.0.2 performance problem. SOLVED.
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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: Does anyone have a Quick and Easy/Dirty HW benchmark for Oracle DB ?
try dbtools / db benchmark expert http://www.softtreetech.com/ There have that you want -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Hemant K Chitale Enviado el: lunes, 20 de enero de 2003 6:39 Para: Multiple recipients of list ORACLE-L Asunto: Does anyone have a Quick and Easy/Dirty HW benchmark for Oracle DB ? I am looking for a quick and easy HW benchmark for an Oracle database. Now, before everyone starts jumping on the word benchmark, I just need something that can be setup in an hour or two, simulate 1 to 1 million transactions and 1 to 50 users with Insert/Update statements. The benchmark is to be run on an HP PA-RISC HPUX machine and a Sun SPARC Solaris machine to get a quick-and-easy/dirty feel of the performance of the two processors. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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).
Oracle 9.2.0.2 performance problem
Hello We have an serious performance problem on aDSS db. We buy a new HP rp5405 (2x650Mhz, 4GB, ...) with HP UX 11.11 Oracle 9.2.0.2 tooks 30 min doing this query where an Intel 2x1,4 Ghz tooks 9 min only. We have in the HPlosts of buffers(1,5GB), sga(200MB), pga(500MB), fast i/O (EMC Clariom CX600)... We try lost of parameters, but time is always the same. Is there some bug in this release - platform? How can I get more data about this problem?? Thanks. SELECT grupo,evpamb,evpdel,evpfor,evppr2,evppr3,evppr4, evpanc,evpgru,evpcli,evppai,evppro,evpume, to_date(evpano||'-'||evpmes||'-'||'01','-MM-DD') FECHA, sum(evppca) PPTO FROM DW.SUPUESTOSGROUP BY grupo,evpamb,evpdel,evpfor,evppr2,evppr3,evppr4, evpanc,evpgru,evpcli,evppai,evppro,evpume, evpano, evpmes call count cpu elapsed disk query current rows--- -- -- -- -- -- --Parse 1 0.01 0.00 0 0 0 0Execute 1 0.00 0.00 0 0 0 0Fetch 445920 1748.65 1708.72 1554 1675 23 445919--- -- -- -- -- -- --total 445922 1748.66 1708.72 1554 1675 23 445919 Misses in library cache during parse: 1Optimizer goal: CHOOSE Parsing user id: 90 (recursive depth: 1) Execution Plan-- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=4481 Card=464215 Byt es=32495050) 1 0 SORT (GROUP BY) (Cost=4481 Card=464215 Bytes=32495050) 2 1 TABLE ACCESS (FULL) OF 'SUPUESTOS' (Cost=162 Card=464215 Bytes=32495050) Statistics-- 0 recursive calls 31 db block gets 1675 consistent gets 1577 physical reads 0 redo size 9012743 bytes sent via SQL*Net to client 208363 bytes received via SQL*Net from client 29729 SQL*Net roundtrips to/from client 0 sorts (memory) 1 sorts (disk) 445919 rows processed stastpack_report1.sql Description: Binary data
RE: Oracle 9.2.0.2 performance problem
Hello We execute the query in the servers, so there is no NET problem (I think). The data volume is exact (imported). Execution path is the same, full-scan. This is a very strange problem and is very important for us to solve it. Thank´s This is the plan of the windows db: Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=5952 Card=465110 Byt es=32557700) 10 SORT (GROUP BY) (Cost=5952 Card=465110 Bytes=32557700) 21 TABLE ACCESS (FULL) OF 'SUPUESTOS' (Cost=643 Card=465110 Bytes=32557700) Statistics -- 0 recursive calls 4 db block gets 6679 consistent gets 12866 physical reads 0 redo size 26428556 bytes sent via SQL*Net to client 3894740 bytes received via SQL*Net from client 59454 SQL*Net roundtrips to/from client 0 sorts (memory) 1 sorts (disk) 445919 rows processed -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de chao_ping Enviado el: lunes, 20 de enero de 2003 12:19 Para: Multiple recipients of list ORACLE-L Asunto: Re: Oracle 9.2.0.2 performance problem Juan Miranda, It seems quite strange,there is little wait event in the statspack report, and you execution path should be the same on both platform, right? And is the data volumn the same in both platform?And does the time spent on fetch the result from server to your client different?Is the speed of your pc to linux and hp the same? Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) === 2003-01-20 01:59:00 ,you wrote£º=== Hello We have an serious performance problem on a DSS db. We buy a new HP rp5405 (2x650Mhz, 4GB, ...) with HP UX 11.11 Oracle 9.2.0.2 tooks 30 min doing this query where an Intel 2x1,4 Ghz tooks 9 min only. We have in the HP losts of buffers(1,5GB), sga(200MB), pga(500MB), fast i/O (EMC Clariom CX600)... We try lost of parameters, but time is always the same. Is there some bug in this release - platform ? How can I get more data about this problem?? Thanks. SELECT grupo,evpamb,evpdel,evpfor,evppr2,evppr3,evppr4, evpanc,evpgru,evpcli,evppai,evppro,evpume, to_date(evpano||'-'||evpmes||'-'||'01','-MM-DD') FECHA, sum(evppca) PPTO FROM DW.SUPUESTOS GROUP BY grupo,evpamb,evpdel,evpfor,evppr2,evppr3,evppr4, evpanc,evpgru,evpcli,evppai,evppro,evpume, evpano, evpmes call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- - - Parse1 0.01 0.00 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 445920 1748.651708.72 1554 1675 23 445919 --- -- -- -- -- -- - - total 445922 1748.661708.72 1554 1675 23 445919 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 90 (recursive depth: 1) Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=4481 Card=464215 Byt es=32495050) 10 SORT (GROUP BY) (Cost=4481 Card=464215 Bytes=32495050) 21 TABLE ACCESS (FULL) OF 'SUPUESTOS' (Cost=162 Card=464215 Bytes=32495050) Statistics -- 0 recursive calls 31 db block gets 1675 consistent gets 1577 physical reads 0 redo size 9012743 bytes sent via SQL*Net to client 208363 bytes received via SQL*Net from client 29729 SQL*Net roundtrips to/from client 0 sorts (memory) 1 sorts (disk) 445919 rows processed = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: how to release blocks of table?
select table_name, monitoring, cache from dba_tables where owner='EPSILON' and (cache not like '%N%' or monitoring'NO'); spool off prompt Indices NO VALIDOS: select * from dba_indexes where status'VALID'; ++ -Mensaje original- De: [EMAIL PROTECTED] [mailto:root;fatcity.com]En nombre de Gogala, Mladen Enviado el: jueves, 17 de octubre de 2002 21:00 Para: Multiple recipients of list ORACLE-L Asunto: RE: how to release blocks of table? If you are using at least 8i, alter table move should do the trick. -Original Message- From: Yechiel Adar [mailto:adar76;inter.net.il] Sent: Thursday, October 17, 2002 2:20 PM To: Multiple recipients of list ORACLE-L Subject: how to release blocks of table? I need to release blocks belonging to the initial extent of a table. CTAS is not an option. Optionally how can I decrease the value of initial extent so I can export and import into smaller size. I have a 7GB database that I need to run a script that was given by supplier. This script rebuild all the indexes and I want to make sure that none are forgotten (~ 700). I have enough space for one but not for two. So I thought to import with rows=no twice, run the scripts against one schema and use toad to compare the schemas. The problem is initial extents in the export file that fill all the new DB. If I can decrease the initial extents then I will export and import the whole schema and have enough space. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Juan Miranda 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: Moving data between tablespaces
To: Multiple recipients of list ORACLE-L
Karthik,
Look at the ALTER TABLE {table_name} MOVE {tablespace}; command.
It will do exactly what you want.
You can also ALTER INDEX {index_name} REBUILD {tablespace} to move indexes.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, September 17, 2002 4:58 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Some of my tables are accidentally created in the SYSTEM tablespace.
Is there any way to move the records and the table to some other tablespace?
regards,
Karthik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Karthikeyan S
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Juan Miranda
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: PL/SQL Editor
PL/SQL Developer. http://www.allroundautomations.nl/plsqldev.html very very good. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ofer Harel Enviado el: miércoles, 28 de agosto de 2002 9:13 Para: Multiple recipients of list ORACLE-L Asunto: RE: PL/SQL Editor Try free Toad at http://www.toadsoft.com/downld.html regards Ofer Harel DBA team Barak ITC [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 8:33 AM To: Multiple recipients of list ORACLE-L Hi All, which is the best PL/SQL editor available as a trial version . the editor should support Oracle sql,PL/SQL and may or may not support debugging. The tool should be support Win 9X OS and provide best performance . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Juan Miranda 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).
RE: Resizing of redo log
You must create other groups, make alter system switch logfile (until CURRENT is one of the new), and delete old groups. You can change log_checkpoint_interval and log_checkpoint_timeout. Use Enterprise Manager. It´s easy. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Pawan Dalmia Enviado el: martes, 27 de agosto de 2002 13:18 Para: Multiple recipients of list ORACLE-L Asunto: Resizing of redo log How is it possible to increase the size og online redo log files Regards Pawan Dalmia -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Juan Miranda 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).
RE: SCO UNIX
8.1.7 is terminal release for SCO. If you want Intel hardware, use Linux (Suse ? - Red Hat ?) -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Atul Kumar Srivastav Enviado el: lunes, 19 de agosto de 2002 14:59 Para: Multiple recipients of list ORACLE-L Asunto: SCO UNIX Hi everybody, Could anybody tell which is the latest version of SCO UNIX. and does Orale 8i DB works on that. Any info of Oracle on SCO unix. Thanx in advance, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Atul Kumar Srivastav 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Juan Miranda 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).
RE: Textfile into oracle
There are some posibilities: - Make an ORacle - Object program in Excel and insert data into Oracle. Look at c:\orant\oo4o directory. - Export data (Save as) from Excel to an csv file and them import into ORacle using SQLLoader. (Open file with wordpad). -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de [EMAIL PROTECTED] Enviado el: jueves, 06 de junio de 2002 12:04 Para: Multiple recipients of list ORACLE-L Asunto: Textfile into oracle Hallo, I have this excelfile. Is it possible to import this into an oracle table. This file is supposed to be located on unix machine from the beginning and the import into an oracle table would be done from unix. How should I name the fields in the oracle table. I mean should I use the 9-10 different field names in the excelfile. There is at least 100 different columns in this excelfile. Is it possible to import a file like that into oracle table, Please help me with some hints. (See attached file: try.xls) Thanks in advance Roland tr2y.csv Description: Binary data
