RE: Spool Oracle Tables into Excel Format
Sure. Use ',' as colsep, and have file extension csv. Jun -Original Message- Sent: Friday, September 20, 2002 4:33 PM To: Multiple recipients of list ORACLE-L All, Is it possible to create Oracle reports into Excel format ? Is it possible to spool Oracle tables into Excel format? Thanks in Advance Bob __ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Robert 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: Feng, Jun 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: SIMPLE QUESTION
Here is what we did. 1. Disable VCS; 2. lsnrctl> set current_listener LISTENERedb; 3. lsnrctl> set log_status off; 4. rename listeneredb.log to listeneredb.log.old; 5. lsnrctl> set log_status on. -Original Message- Sent: Wednesday, May 01, 2002 1:18 PM To: Multiple recipients of list ORACLE-L HI AGAIN, JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY TO RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD ONE IS USING BY ORACLE. HOW CAN I TRUNCATE THE LISTENER.LOG OR CAN I JUST SIMPLY DELETE IT OR NOT? THANKS FOR HELP. Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Feng, Jun 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).
Why LOADS > EXECUTIONS
Hi, I found that there are some SQL statements in the v$sqlarea. The LOADS is much high than EXECUTIONS. Could anyone give some explanation? Thanks, Jun Here are some examples: SQL LOADS COUNT(*) TotExecs -- -- -- INSERT INTO PERSON_ORG_STATE_HIS ( STATE9948398 1 639075 INSERT INTO PERSON_ORG_STATE_HIS ( STATE8844933 1 359875 INSERT INTO PERSON_ORG_PROD_INST_XREF ( 15 1 7 INSERT INTO PERSON_ORG_ACCOUNT_XREF ( PE9200815 1 272364 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Feng, Jun 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: Problem importing objects to different tablespace
The default tablespace is only used whenever there is no tablesapce parameter in the crate and alter table/index statements. Since the export always have tablespace parameter with the create table/index statement, your import method definitely will fail. You can change the tablespace for the segment by creating the segment in the desired tablesapce first, then import. Jun -Original Message- Sent: Tuesday, November 27, 2001 2:05 PM To: Multiple recipients of list ORACLE-L Guys, I'd appreciate any help that I could get. I was trying to import to another tablespace, same user. I hadn't had a need to do this in a while but thought this shouldn't be too difficult. So I did what the manuals said: ran a user export set user's quota on old tablespace to 0 granted unlimited quota to user on new tablespace revoke resource, unlimited tablespace privs from user make new tablespace default for user Then when I ran the import with ignore=y I got the error "space quota exceeded for tablespace " for all create table commands. Bottom line is, it didn't import the tables. Reading the manuals and Metalink docs, the process looked really straightforward. Does anybody know of anything that I've missed? Thanks, George -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena 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: Feng, Jun 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).
Repost: Nested loop in PL/SQL
Sorry, I meant to say doesn't work. -Original Message- Sent: Monday, October 01, 2001 6:50 PM To: Multiple recipients of list ORACLE-L Could anyone tell me why following nested loop does work? It stopped after inner loop finished. I tried for loop, it worked ok. Thanks, Jun declare v_plan_id number; v_channel_id pricing_plan.channel_id%TYPE; v_row pricing_plan%ROWTYPE; cursor plan_id is select distinct pricing_Plan_id from pricing_plan where CHANNEL_ID = 'GROUP19' and promotion_cd = 'INFO' and trunc(end_date) >= trunc(sysdate) and p_mode = 'LIVE' group by PRICING_PLAN_ID; cursor channel_id is select distinct channel_id from pricing_plan where CHANNEL_ID not in ('GROUP1','GROUP2', 'GROUP3') and transaction_type = 'REGISTRATION' order by channel_id; begin open plan_id; open channel_id; loop fetch plan_id into v_plan_id; exit when plan_id%NOTFOUND; loop fetch channel_id into v_channel_id; exit when channel_id%NOTFOUND; select * into v_row from pricing_plan where PRICING_PLAN_ID = 1; dbms_output.put_line(v_row.price_cd); end loop; end loop; close plan_id; close channel_id; end; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Feng, Jun 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: Feng, Jun 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).
Nested loop in PL/SQL
Could anyone tell me why following nested loop does work? It stopped after inner loop finished. I tried for loop, it worked ok. Thanks, Jun declare v_plan_id number; v_channel_id pricing_plan.channel_id%TYPE; v_row pricing_plan%ROWTYPE; cursor plan_id is select distinct pricing_Plan_id from pricing_plan where CHANNEL_ID = 'GROUP19' and promotion_cd = 'INFO' and trunc(end_date) >= trunc(sysdate) and p_mode = 'LIVE' group by PRICING_PLAN_ID; cursor channel_id is select distinct channel_id from pricing_plan where CHANNEL_ID not in ('GROUP1','GROUP2', 'GROUP3') and transaction_type = 'REGISTRATION' order by channel_id; begin open plan_id; open channel_id; loop fetch plan_id into v_plan_id; exit when plan_id%NOTFOUND; loop fetch channel_id into v_channel_id; exit when channel_id%NOTFOUND; select * into v_row from pricing_plan where PRICING_PLAN_ID = 1; dbms_output.put_line(v_row.price_cd); end loop; end loop; close plan_id; close channel_id; end; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Feng, Jun 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: Physical access to servers for maintenance
Only thing we are having is installing the software, like Oracle8i, it not only needs mount the CD, also needs change the CD in the middle. If you only have the PC, I don't know how you can install Oracle on UNIX without access the UNIX box. Maybe SA will take care all the software installation. Jun -Original Message- Sent: Tuesday, September 25, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Our hardware people are cracking sown on access to the computer room. They have decided the DBA group can do all their work without going to the server itself. This includes Unix and NT server running both Oracle and SQL Server. We would have to use VNC Viewer and PC Anywhere. I am trying to put together a list of things we might need to do that would make remote admin difficult as well as taking longer. If you have any ideas I would appreciate it. Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. 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: Feng, Jun 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: Create excelfile from pl/sql
Save the file with .csv extension, use comma (,) as delimiter, put column in double quote ("). Here is an example. "","","","13314 Xya Street","","","","","HOUSTON","TX","77041","US","MY.COM" "","","","1512 Dark Ave. N.","","","","","SEATTLE","WA","98109","US","YOUR.COM" "","","","1512W 23th SUITE I","","","","","EMPORIA","KS","66801","US","THEIR.NET" Jun -Original Message- Sent: Monday, September 24, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Hallo, How can I create a excelfile with the UTL_FILE packet, I wantthe file to be able to opened directly in excel, without goingthrough the import step when I open the file. Give me an example, please. Roland -- 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: Feng, Jun 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).
Create user identified by externally
Hi, If there is user created using identified by externally, could this user login to database remotely? If it could, could you please help us? Thanks, Jun -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Feng, Jun 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: Copy Oracle's binary.
Your were right. If you want to upgrade the copied Oracle, you would have problem. What we did was move the executables from environment to environment, so we only do one time install on development machine, and copy the executables to all others (test and product). Jun -Original Message-From: Kimberly Smith [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 7:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Copy Oracle's binary. Have you upgraded those databases? Its no longer possible to just copy ORACLE_HOME and expect to be able to upgrade it. That being said, I never did bother to identify the other directories as I felt it was just as easy to install the software. You could do a full system copy though. -Original Message-From: Feng, Jun [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 3:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Copy Oracle's binary. Sure. We have done that many times. Jun -Original Message-From: Thanh-truc Nguyen [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 6:31 PMTo: Multiple recipients of list ORACLE-LSubject: Copy Oracle's binary. Hello, I've two machines (with the same unix's configuration on Sun Solaris). On has Oracle 8.1.7. installed and a database. Do you think it's possible to copy Oracle's binary and the database on Unix level to the new serveur instead of installing and cloning the db ? Thank you very much. Thanh-truc Nguyen
RE: Copy Oracle's binary.
Sure. We have done that many times. Jun -Original Message-From: Thanh-truc Nguyen [mailto:[EMAIL PROTECTED]]Sent: Monday, September 17, 2001 6:31 PMTo: Multiple recipients of list ORACLE-LSubject: Copy Oracle's binary. Hello, I've two machines (with the same unix's configuration on Sun Solaris). On has Oracle 8.1.7. installed and a database. Do you think it's possible to copy Oracle's binary and the database on Unix level to the new serveur instead of installing and cloning the db ? Thank you very much. Thanh-truc Nguyen
RE: Read only snapshot
We are using Oracle 8.1.6.3 on Solaris 2.6. We are having performance problem. For the very short period, the CPU usage would get to 100%. We found that there were a group of tables locked by same session and that session was in the 'INACTIVE' mode. In those tables, there always had table "MLOG$***" which is snapshot log. Is this normal for the snapshot? Thanks, Jun -Original Message- Sent: Sunday, September 16, 2001 5:15 AM To: Multiple recipients of list ORACLE-L Hi What is exactly your Problem ? With which Oracle - Versions ? Regards Rudi - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, September 15, 2001 1:35 AM > !! Please do not post Off Topic to this List !! > > All, > > We are trying to implement the read only snapshot, but having a lot of > problems. Could anybody share your experience with us? > > Your help is very appreciated. > > Jun > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Feng, Jun > 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: =?iso-8859-1?Q?Konrad_B=FCKo?= 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: Feng, Jun 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).
Read only snapshot
!! Please do not post Off Topic to this List !! All, We are trying to implement the read only snapshot, but having a lot of problems. Could anybody share your experience with us? Your help is very appreciated. Jun -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Feng, Jun 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).
Object-Oriented Features
Hi, Anyone used Oracle Object-Oriented Features, or going to use them. How good or bad are they? Any comments are appreciated. Thanks, Jun -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Feng, Jun 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: Dropping partitions with data versus empty
We have that kind application running on the production and didn't have any problem since it was deployed last Oct.. The application will truncate the one of the table partitions which contains 99% of the data (about 7M records) before reload the data every two weeks. For you situation, you can truncate partition then drop it. It is easy, clean and quick. Jun -Original Message- Sent: Friday, April 13, 2001 10:12 AM To: Multiple recipients of list ORACLE-L Anyone have any problems dropping partitions that hold data? We are debating the risk involved in dropping populated partitions as opposed to purging the data out of them first and then dropping them (a lot of work). Theoretically, this should work o.k. but has anybody actually had problems doing this? Cherie -- 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: Feng, Jun 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: OID installation
Deinstall the product and reinstall it. You may also configure OID manually. Jun -Original Message- Sent: Monday, April 09, 2001 11:46 AM To: Multiple recipients of list ORACLE-L I'm looking for help installing Oracle Internet Directory (8.1.7, Sun Solaris 2.7). The software installation goes fine, but once the OID Configuration Assistant window comes up, everything stops. My database does use the UTF8 character set. Any ideas out there? Thanks. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel 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: Feng, Jun 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: Script to know the size of each table in a schema ?
ph S. Testa 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: Feng, Jun 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).
FW: Upgrade Oracle8.1.6 to 8.1.7
It should be database upgrade from Oracle8.1.6 to Oracle8.1.7. Sorry, Jun -Original Message- Sent: Tuesday, February 06, 2001 11:56 AM To: Multiple recipients of list ORACLE-L > Hi > > We are preparing for database upgrade from Oracle8.1.6 to Oracle8.1.6. > Have anybody done this work without database downtime? What was your > downtime window for upgrade? Anybody have any suggestions about the > upgrade without downtime? > > Thanks, > > Jun -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Feng, Jun 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: Feng, Jun 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).
FW: Upgrade Oracle8.1.6 to 8.1.7
> Hi > > We are preparing for database upgrade from Oracle8.1.6 to Oracle8.1.6. > Have anybody done this work without database downtime? What was your > downtime window for upgrade? Anybody have any suggestions about the > upgrade without downtime? > > Thanks, > > Jun -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Feng, Jun 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).
Upgrade Oracle8.1.6 to 8.1.7
Hi We are preparing for database upgrade from Oracle8.1.6 to Oracle8.1.6. Have anybody done this work without database downtime? What was your downtime window for upgrade? Anybody have any suggestions about the upgrade without downtime? Thanks, Jun -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Feng, Jun 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).