RE: Excel to Oracle
Hi... Here we use a text file .css generated in Excel and then we use sqlloader... it's very fast.. bye ATT Latin America Alex Tomita Koga - ITS e-mail: [EMAIL PROTECTED] phone: (51) 1 610- extension 2619 Av. Larco 1301 Torre Parque Mar - Miraflores -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Enviado el: Lunes, 18 de Marzo de 2002 10:44 a.m. Para: Multiple recipients of list ORACLE-L Asunto: Excel to Oracle Hi All, What is the best/quickest way to move data from excel to Oracle? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Tomita Koga, Alex - (Per) 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: How TO KNOW TABLE SIZE
Check this note from metalink. *** Title: Script to compute table size Disclaimer: This script is provided for educational purposes only. It is NOT supported by Oracle Support Services. The script has been tested and appears to work as intended. However, you should always test any script before relying on it. PROOFREAD THIS SCRIPT PRIOR TO USING IT! Due to differences in the way text editors, email packages and operating systems handle text formatting (spaces, tabs and carriage returns), this script may not be in an executable state when you first receive it. Check over the script to ensure that errors of this type are corrected. Abstract: It is sometimes necessary to calculate the exact size (exact number of bytes) of a table. The function 'VSIZE' gives the exact number of bytes allocated by Oracle for data. For example, if you have a table called 'table1' with n columns say, 'col1', 'col2', , 'coln', execute the following SQL statement to find the exact size of the table: SELECT SUM(VSIZE(col1)) + SUM(VSIZE(col2)) + ... + SUM(VSIZE(coln)) FROM table1; In the scott/tiger schema, the following SQL statement can be executed to find the exact table size of the 'DEPT' table: SQL SELECT SUM(VSIZE(deptno)) + SUM(VSIZE(dname)) + SUM(VSIZE(loc)) FROM dept; SUM(VSIZE(DEPTNO))+SUM(VSIZE(DNAME))+SUM(VSIZE(LOC)) 88 Requirements: None Version Testing: This script was tested on Oracle 7.3.3 to 8.1.6 and SQL*Plus *** ATT Latin America Alex Tomita Koga - ITS e-mail: [EMAIL PROTECTED] phone: (51) 1 610- extension 2619 Av. Larco 1301 Torre Parque Mar - Miraflores -Mensaje original- De: Seema Singh [mailto:[EMAIL PROTECTED]] Enviado el: Lunes, 04 de Marzo de 2002 02:08 p.m. Para: Multiple recipients of list ORACLE-L Asunto: How TO KNOW TABLE SIZE Hi How can I know how much space a table occupied? Can BLOCKS columns in dba_tables helps? Or I have to use dba_extents and dba_segments tables? Thx -Seema _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Tomita Koga, Alex - (Per) 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).
Oracle 9i Problem
Hi I have some problems with Oracle 9i for Linux, I downloaded the files from OTN then I did all the steps that otn said: 1. Run gunzip filename on all the files. - Eg.: gunzip Linux9i_Disk1.cpio.gz 2. Extract the cpio archives with the command cpio -idmv filename - Eg.: cpio -idmv Linux9i_Disk1.cpio but the second step did not work... I didn't see any files!! What's wrong?... Thanks Alex Tomita -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tomita Koga, Alex - (Per) 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-06502
How can I resolve this error? Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ATT Latin America Alex Tomita Koga Information Technology (IT) e-mail: [EMAIL PROTECTED] phone: (511) 610 (2619) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tomita Koga, Alex - (Per) 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).
HELP!!!
I need more information about these components: Oracle Office Automation and Oracle On-Line Text Viewer. When I try to install Oracle 8i Release 8.1.7 EE I didn't see these components I want to know where I could find these, or maybe in this version they have other names. Thanks Alex -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tomita Koga, Alex - (Per) 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).
Oracle - Components
Hi guys, I need to find these oracle components: Oracle Office Automation and Oracle On-Line Text Viewer. I have Oracle 8i Release 8.1.7 Enterprise Edition... When I install Oracle, I don't see these components !!!... it's urgent!!. Thank you guys!! Alex -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tomita Koga, Alex - (Per) 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).