trying to order date chronologically
Is there a way to order the result set of a query by date chronologically? For example, I run a usage report for customers either monthly, quarterly, semi annual or annually. I need to return the result set chronologically by month and I cannot seem to find a way to do it. Thanks for any help! Sebastian DiFelice Database Administrator Thomson Corporation Intelligence Data (617) 856-1587 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DiFelice, Sebastian 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).
migrated from 8.1.5 to 8.1.7 and Migration Assistant moved my $OR
can anyone tell me why this happened? Sebastian DiFelice DBA/Database Analyst Thomson Intelligence Data (617)856-1587 www.intelligencedata.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DiFelice, Sebastian 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: migrated from 8.1.5 to 8.1.7 and Migration Assistant moved my
When I upgraded and migrated from 8.1.5 to 8.1.7 the Universal Installer/Migration Assistant moved my $ORACLE_BASE from /disk03/app/oracle to /disk03/app/oracle/product/8.1.5 (which is my $ORACLE_HOME) without prompting me for the move. SD -Original Message- Sent: Friday, September 20, 2002 10:19 AM To: Multiple recipients of list ORACLE-L my can you better explain what the question is? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September 20, 2002 9:48 AM To: Multiple recipients of list ORACLE-L $OR can anyone tell me why this happened? Sebastian DiFelice DBA/Database Analyst Thomson Intelligence Data (617)856-1587 www.intelligencedata.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DiFelice, Sebastian 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: Mercadante, Thomas F 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: DiFelice, Sebastian 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).
problems creating a context index
Hello All; I am being plagued with an error I can't get my hands around when I try to recreate a context index. The index existed previously, but when I tried to sync new data I got an error, then I attempted rebuilding the index from scratch and got the same error (see below). I checked the $ORACLE_HOME/lib directory and found the library that the error indicates as missing. Any help would be greatly appreciated! sql statements executed: call Ctx_Ddl.Drop_stoplist ('my_stoplist') / call Ctx_Ddl.create_stoplist('my_stoplist') / drop index TFNR_DISPLAY_NAME_IDX_C / create index TFNR_DISPLAY_NAME_IDX_C on TFNR (Display_Name) indextype is ctxsys.context parameters ('stoplist my_stoplist') / error returned: Call completed. Call completed. drop index TFNR_DISPLAY_NAME_IDX_C * ERROR at line 1: ORA-01418: specified index does not exist create index TFNR_DISPLAY_NAME_IDX_C on TFNR (Display_Name) * ERROR at line 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-2: ConText error: ORA-06520: PL/SQL: Error loading external library ORA-06522: ld.so.1: extprocPLSExtProc: fatal: libskgxp8.so: open failed: No such file or directory ORA-06512: at CTXSYS.DRUE, line 122 ORA-06512: at CTXSYS.TEXTINDEXMETHODS, line 34 ORA-06512: at line 1 Sebastian DiFelice DBA/Database Analyst Thomson Intelligence Data (617)856-1587 www.intelligencedata.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DiFelice, Sebastian 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).
any tips on migrating from 7.3.4 to 8.1.7
Hello All, I am currently involved in a migration project which involves combining two disparate databases into a single Oracle Engine. One of the databases currently lives on Oracle 7.3.4 and the other is 8.1.5 (both desupported by Oracle). My task is to upgrade to a single instance of 8.1.7 (and eventually 9.2.x). Are there any road bumps that I should be aware of before undertaking this endeavor? Any tricks/tips are appreciated. Thank you in advance Sebastian DiFelice DBA/Database Analyst Thomson Intelligence Data (617)856-1587 www.intelligencedata.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DiFelice, Sebastian 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).