array question ???
Hi all, How to work with Array in PL/SQL. I have an input string like 12,34,56,.. I need to get the values out and assign them to an array, and loop through the array to call a function. Do you have sample code for 1) value assignment to array and 2) loop through array. And it's all in pl/sql. Thank you. Andrea __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrea Oracle 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).
convert number to word ???
Hi, Is there a function that can conver number to word? ef: 100 is ONE HUNDRED, 2003 is TWO THOUSAND AND THREE. Thank you in advanced!!! __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrea Oracle 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).
date checking ???
Hi all, May I ask a javascript question?? (sorry to post here!) below is a form checking input date. The input date cann't be earlier than today. But it also compares hours and minutes which I don't want. Suppose you input 08/20/2003, it thinks it's 08/20/2003 00:00:00 which is earlier than now (08/20/2003 15:30:00). How to solve this?? Thank you! html head script function validate(){ var obj = document.forms(shipping); //$$ sending date cannot be earlier than today now = new Date(); sDate = obj.p_sending_date.value; sDate = sDate.substring(0,2) + / + sDate.substring(3,5) + / + sDate.substring(6,10); inputDate = new Date(sDate); if (inputDate now) { alert(Sending date cannot be earlier than today.); }else{ alert(ok); } } /script /head body form name=shipping input type=text name=p_sending_date input type=submit value=submit onClick=validate(); /form /body /html __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrea Oracle 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 calculate the working hours?
Hi, I haven't got too many response to my working hour question, probably because I sent it out late Friday night. Let me send that question again, really appreciate your help! -- We have open Time for every order, ef: Open Time -- 03/12/03 11:08:07 How to calculate the working hours (8am - 5pm, no weekends) that a file remain open until now? (Sysdate - Open_Time) returns all the hours including weekend and 8am, 5pm hours. We only like to know the WORKING hours. Thank you so much! Andrea __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrea Oracle 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 get working hours ???
Hi, We have open Time for every order, ef: Open Time -- 03/12/03 11:08:07 How to calculate the working hours (8am - 5pm, no weekends) that a file remain open until now? (Sysdate - Open_Time) returns all the hours including weekend and 8am, 5pm hours. We only like to know the WORKING hours. Thank you so much! Andrea __ Do you Yahoo!? Yahoo! Web Hosting - establish your business online http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrea Oracle 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).
sql question ???
Hi, I got a SQL question (9i on Red Hat), commands shown below. The first sql returns 3 rows with value 1, so trim(client_company) = '', how come the 2nd sql doesn't return anything?? SQL select decode(trim(client_company), '', 1, ' ', 2, null, 3, 4) from cli_clients where cli_id in (257, 396, 727); DECODE(TRIM(CLIENT_COMPANY),'',1,'',2,NULL,3,4) --- 1 1 1 3 rows selected. SQL select count(*) from cli_clients where trim(client_company) = '' and cli_id in (257, 396, 727); COUNT(*) - 0 1 row selected. __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrea Oracle 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).
Unix research source ???
Hi all, Does Unix has an on-line research source, like metalink for Oracle? Pls send me the links. Much appreciated. Also is Linux pretty similar to Unix. What's the major difference? Thank you in advance! Andrea __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrea Oracle 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).
cannot find database in OEM ???
Hi all, I created one db and after OEM discovered node, that db shows on navigator. I created another database, I refreshed the node, the new db did NOT show; then I deleted the old node, and did a discover again, but the new db still did not show. Metalink suggests refresh twice it will work, but it didn't work for me. If I use Launch Standalone, all the db can be found, but I have to use ManagementServer. What should I do? Thank you! OEM is a part of Oracle9i, on Win2000. Andrea __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
OEM service problem ???
Hi, After I installed 9i on win2000, the OEM 9.0.1 is automatically installed. I configured a database for OEM repository, the config went fine. But when I tried to start ManagementService, I got: Could not start the OracleORA9iManagementServer service on Local Computer. Error 1053: The service did not respond to the start or control request in a timely fashion. I rebooted and restarted and still got this. What went wrong ??? What should I do? Thank you! Andrea __ Do You Yahoo!? Yahoo! Greetings - Send FREE e-cards for every occasion! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
where to download designer 6i ?
Hi, I tried to download Designer 6i from OTN, but I got: Oracle Designer 6i Release 4.1.1 (Coming Soon) Does anyone know where can I download release 4 or release 3? Thank you. Andrea __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
designer6i vs. designer2000
Hi, Is Designer 2000 and Designer 6i similar? They are about data modeling, aren't they. If I'd like to learn one, which one do you recommended? Thanks! Andrea __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
function help ???
Hi, Could any one show me how to write the following function? Thank you very, very much! The GPA Function 1. A GPA is calculated in the following fashion: Assume a student receives an A on a 3-credit_hour course and a D on a 2-credit-hour course. His grade is (4*3+1*2)/(3+2)=2.8. 2.Repeat_delete Policy: A student may repeat a course as many times as he wants. However, if the first grade he receives on this course is a D or F, then the second grade will automatically replaces the first grade, and the first enrollment will not go into his GPA calculation. Under any other circumstances, his grades will be considered as a regular grade and be taken into consideration for GPA. create table Enrollment( Student# NUMBER (7), SNUM NUMBER (5), Call# NUMBER (7), Semester char (8), GRADE char (3), Credit number, Withdraw_Date Date); SNUM + Call# represents one class. Insert into Enrollment values('58001','111','70070','Sp2000','F',3, null); Insert into Enrollment values('58001','111','70070','Fa2000','B',3, null); Insert into Enrollment values('58003','222','70070','Sp2000','A',2, null); Insert into Enrollment values('58004','333','80025','Fa2000','A',2, null); Insert into Enrollment values('58005','222','80025','Fa2000','C',3, null); __ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
frequent commit ???
Hi all, I'm updating 1 million row, is it a way to do a commit after every 1000 rows? Thank you! Andrea __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
frequent commit, example ??? HELP
Hi all, Thank you all those for responding to the frequent commit question. So members suggested using count, and loop. May I have real example. (OK, I'm bad at pl/sql). Site table has 2 million rows, how to so a commit, let's say 5000 rows. Site_id is unique in site table. How does the counter fit in the following update sql? update site a set a.site_code = (select c.area_code from site_location b, area c where a.site_id = b.site_id and c.area_id = b.area_id); I put a counter is a sample code, and update runs 10 times! then commit, then runs another 10 times! then commit I must miss something. Please give me as mush detail as you can. Thank you so much! Andrea __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
BLOB ???
Hi, all I have a table that has a column with BLOB data type. When I do a select I got: SP2-0678: Column or attribute type can not be displayed by SQL*Plus And I don't know how the data got inserted there. Could anyone let me know how to insert and display BLOB contents. Thank you! Andrea __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
How to put if statement with Accept value ???
Hi all, How to do a if statement with Accept? Like I first prompt user for a value, Accept var prompt ..., then based on the value I got, do differenct things. (Oracle 815 on Sun) Thank you! Andrea __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
copy cursor ???
Hi, all Is there a way to clone/copy a cursor? I have a cursor, after looping throught it, I would like to go to the beginning and loop again. If I open the cursor again, my impression is that the cursor does a new select, which might not return the exact same rows as before, since the data got changed all the time. If I open the cursor twice in delcare section, the two cursor might not be the same, since it took about 3 minutes to do the select. So how can I work on two EXACTLY same copies of the cursor? Thank you! Andrea __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
objects in a wrong place ???
Hi all, I did a full database import. After the import, the tables went to the correct schema owner, but procedures went to owner SYSTEM !!! How does this happen, and how to move these to the correct schema? Thank you! Andrea __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
strange problem with v$recover_file ???
All, I got a problem with v$recover_file. Somehow the query failed if selecting is on ONLINE column. SQL desc v$recover_file; Name Null?Type - --- FILE# NUMBER ONLINE VARCHAR2(7) ERROR VARCHAR2(18) CHANGE#NUMBER TIME DATE These are OK: --- select CHANGE# from v$recover_file; select TIME from v$recover_file; select * from v$recover_file; However these gave me error: select ONLINE from v$recover_file; select online, ERROR from v$recover_file; select FILE# , ONLINE,ERROR , CHANGE#,TIME from v$recover_file; * ERROR at line 1: ORA-00936: missing expression SQL select v.name, b.online 2 from v$datafile v, v$recover_file b 3 where v.file# = b.file#; select v.name, b.online * ERROR at line 1: ORA-01747: invalid user.table.column, table.column, or column specification What's happening?! Thank you. Andrea __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
How to clear sqlplus settings???
All, How to clear sql plus settings? I have compute sum of bytes on report for one sql, and cannot get rid of it, now sqlplus computes total whenever I have a bytes column. The same thing for other settings. So what's the way to clear col, ttitle, compute, pagesize, linesize, variables, and other settings you know. Thank you! Andrea __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
Index question ???
Hi, all I got couple of indices questions: Is it REQUIRED or just recommended to build an index on FK column/s? I used Alter Table ... Move and Alter Index ... Rebulid to move the table into differenct block and then rebuild index. Table Move works fine, but after index rebuilt, some indices disappeared! How come? Thanks! Andrea __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
OEM index tuning
Hi all, I run the OEM Oracle Expert for index tuning. It generates a script that I should drop some indexes, and build some indexes. Should I follow what OEM suggests? Is there an easy way to verify whether OEM's suggestion is corret? For example, OEM suggests to bulid index on table1 using col1 and col2. I tried to find a query search using col12 on T1, but didn't find any. (Where did OEM get the idea?) Thanks, Andrea __ Do You Yahoo!? Send instant messages get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
backup, recovery web site ?
Hi, I saw a backup recovery web site a while ago. That site devotes to B R and it claims it has the most knowledge on BR topic. I cannot find it anymore. Does anyone know, or if you have a good site for backup recovery, could you let me know? Thank you in advance. Andrea __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
how to clean NT services ???
Hi all, I installed, deinstalled, and reinstalled some Oracle tools. In the NT service window, I still see the service name for non-extisting services. How can I clean out these services? (NT 4.0, Oracle 815 EE for NT, OEM 204). Thanks. Andrea __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
OEM Data Gatherer question???
Hi, I installed both OEM 204 Tuning Pack and Diagnostic Pack, TP runs very fine. But when I tried to connect to DP's Performance Mananger, I got message VTM 0005 and Data Gatherer is not running. What is this Data Gatherer? and how to run it? Thanks a lot! Andrea __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: OEM Data Gatherer question???
Hi all, First thanks to Bruce, George and Michale who responded. When I tried to run DataGatherer serive on NT 4.0, I got Error 2186: The services is not responding to the control function. Did I miss something? OEM204 is installed on NT40 to monitor 815 database on Sun 5.6, do I also need to run vppcntl start on Unix? I actually did, but still cannot connect. Also, I installed the whole pack of OEM Tuning pack and OEM Diagnose Pack, do they affect each other? Thank you so much! Andrea --- Page, Bruce [EMAIL PROTECTED] wrote: It is another process you need to startup when you startup the agent. -Original Message- From: Andrea Oracle [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 4:15 PM To: Multiple recipients of list ORACLE-L Subject: OEM Data Gatherer question??? Hi, I installed both OEM 204 Tuning Pack and Diagnostic Pack, TP runs very fine. But when I tried to connect to DP's Performance Mananger, I got message VTM 0005 and Data Gatherer is not running. What is this Data Gatherer? and how to run it? Thanks a lot! Andrea __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: Page, Bruce 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). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
OEM Data Gatherer again???
This is really strange. I have a 815 database to be monitored by OEM performance manager, the db is on Sun5.6 box called Torrent, so I start the vppcntl there: jcsora:torrent:/oracle/product/8.1.5/bin$ vppcntl -start The Oracle Data Gatherer is running. There I open the OEM performance manager on NT4.0. I again got the VTM-0005, make sure Data Gatherer is running. Then I used the ping to see is the DG running, and got: jcsora:torrent:/oracle/product/8.1.5/bin$ vppcntl -ping The Oracle Data Gatherer is not running. So I re-started the vppcntl, the ping shows it's running, but right after I tried to connect db through PManager, the ping shows DG is NOT running! Somehow the connection from PManager stopped DG on the server??? I appreciate any help! Andrea --- Page, Bruce [EMAIL PROTECTED] wrote: You need to start it on the server where your database is that you want to monitor. I start mine at the same time that I start the DBSNMP agent. -Original Message- From: Andrea Oracle [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 6:46 PM To: Multiple recipients of list ORACLE-L Subject: RE: OEM Data Gatherer question??? Hi all, First thanks to Bruce, George and Michale who responded. When I tried to run DataGatherer serive on NT 4.0, I got Error 2186: The services is not responding to the control function. Did I miss something? OEM204 is installed on NT40 to monitor 815 database on Sun 5.6, do I also need to run vppcntl start on Unix? I actually did, but still cannot connect. Also, I installed the whole pack of OEM Tuning pack and OEM Diagnose Pack, do they affect each other? Thank you so much! Andrea --- Page, Bruce [EMAIL PROTECTED] wrote: It is another process you need to startup when you startup the agent. -Original Message- From: Andrea Oracle [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 4:15 PM To: Multiple recipients of list ORACLE-L Subject: OEM Data Gatherer question??? Hi, I installed both OEM 204 Tuning Pack and Diagnostic Pack, TP runs very fine. But when I tried to connect to DP's Performance Mananger, I got message VTM 0005 and Data Gatherer is not running. What is this Data Gatherer? and how to run it? Thanks a lot! Andrea __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: Page, Bruce 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). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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
OEM: init, Tuning Pack question ???
Hi all, Me again :-( :-). Thank you all those anwering my previous questions, I made lots of progress! Here are some question/problem I still have :-(: OEM 2.0.4 on NT 4.0, Oracle 815 on Sun 5.6 Tuning Pack Connection Question: I can login to any tool under DBA Managment Pack with no problem. However in Tuning Pack, Tablespace manager, I always got TNS could not resolve service name. The service name was already configured. In Oracle Expert, I tried to create a new session, the db name was pre loaded in a combo box and it's read only, I picked one, and got TNS could not resolve service name. Where did that combo box got loaded?? The db name I picked is already configured, do I need to do some other configuration??? Local Init file Question: In Instance Manager, the DB State is read-only. I saw in the document that: If connected directly to a remote database, you must have a local copy of the INITSID.ORA file to startup the database. May I know where to put this file in my local machine? Once I place this file, can the DB state be editable? Thank you so much!!! Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
OEM help ???
Hi all, I installed OEM816 on NT40, database server is 815 on Sun 5.6. The OEM doesn't run since OMS NT service cannot be started for some reason. I tried to deinstalled OEM using installer, the deinstalling only runs for 2% and jumpped out. So I manually removed all the OEM files, and tried to install again. Now the installer told me that you cannot install this since it's already in oem home directory. and the Installed Products still shows all the OEM products, even though I already got rid off the whole oem home. Are there anything log in the registry or some other places that I should clean out? And does OEM816 works well with 815 database?? Thanks. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
sqlplus question ???
Hi all, I have these in sqlplus: set pagesize 999 Set linesize 100 Col file_name format a50 Col bytes format 999,999,999,999 compute sum of bytes on report select file_name, bytes from dba_data_files order by file_name; The query returns all the data files back, but it did NOT show the sum of the bytes. Is there anything I forgot to set? Thank you. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
Privilege problem ?????
Hi all, I wrote a script for developers to run. I have svrmgrl, connect internal in the script. The developer got error since he doesn't have privileges. So how to make the script runnable by non dbas??? Thanks. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: ORA-06513 ???
Hi, I have a simply SP, which dose an update when criteria matches. It takes 34 IN paramters, if the service_location_id matches what's in the table, then update other 33 columns. It's 815 on Sun 5.6. When I execute it in sqlplus, it works fine. But the programmer told me that he called it using a wrap written in C++, and got error: [SERVERERROR] ORA-06513: PL/SQL: index for PL/SQL table out of range for host language array. The wrap is used to run all the sp/functions, and works very well, except this one. Attached is the procedure. Any idea? Thank you. Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ LP_IVUPDSVCLOC_00.PRC
strange problem after installing Oracle816
Hi all, I installed Oracle8.1.6 on a SunOS 5.6 box. That box already had 815 and 817 installed. When I'm in 816 Oracle_HOME/bin, sqlplus works fine but when I do svrmgrl which does exist, I got this: ld.so.1: svrmgrl: fatal: relocation error: file svrmgrl: symbol kghla42_: referenced symbol not found Killed I got the same error when run in 817home/bin, but in 815/bin, it works just fine. The PATH only have 815home/bin in it. Is it the path problem??? but I was in 816home/bin when I executed svrmgrl. Thank you! Andrea __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
check file size, extension question???
Hi, all I'm writing some auto backup/refresh script, do you know any command that returns only size or extenstion or a file? (there will be only one file in the directory) I know awk can return only a part of the output, but somehow I cann't combine awk and ls -l successfully. ls -s returns some size I don't want, I'd like to have size as shown in ls -l. For the refresh script, I like to check file extension, so if it's in gz, I'll gunzip; if it's Z, I'll uncompress. Thanks! Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
NT script
Hi, Thank you all very much for answering my NT batch script question. Do you mind I ask another one? I pass in SID as a parameter, if they don't pass it in, I'd like to echo out an error message. So how to check whether the parameter is passed in or not? I never write bat file before. Are there some good ways, web site/book/doc that I can do some research by my own, so I don't have to bug people whenever I got a question. Thank you! Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
NT script question ???
Hi, I have couple of questions about bat file in NT 4.0 for Oracle 8.1.5. 1. how to make bat file take parameters. I had a backup.bat, and like to pass in Oracle SID, so the script can backup any database. 2. in the bat file, how to dynamically append date/time into a directory name, like backup_06022001121314 Thank you! Andrea __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
one more question about NT bat script
Hi, one more question about bat script in NT 4.0: when I put del c:\test\*.* in the bat file, and run it, I got Are you sure (Y/N)?, how to surpress this question? Thank you. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
sum of file size ????
Hi, OK, as you know, I don't know too much about Unix: When you do a ls -l and see the individual file size, is there a command to show the sum of all the file size? Thank you! Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
how to make a file writable by anybody?
Hi all, How to make a Unix file writable by anybody? The file should be owned by dba, but also writable by non-dbas. -rw-rw-rw- 1 jcsora dba0 May 21 16:00 dbbackup_sched.dat -rw-rw-r-- 1 jcsora dba0 May 21 16:01 del_base_sched.dat Currently dbbackup_sched.dat file can be written by tester and other people, I'd like to make del_base_sched.dat the same thing. After I did chmod +w del_base_sched.dat, it only changes the 6th character to be w, but not the 9th. Thanks, Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
multiple schema in a database ???
Hi all, We'll have a meeting about the following issue: Due to large amount of transactions each trainee has, the existing training database in Sybase used multiple databases to handle each trainee's transactions. To implement this in Oracle, we may need to create multiple schemas in one Oracle database, instead of creating multiple Oracle databases. Let's investigate the impact of having multiple schema in a database. Looks like Public synonym needs to be get rid off. Any other idea about the impact of having multiple schema? And is there an easy way to create a schema which is identical to another one? Thank you. Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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 HELP !
Hi all, Our trainer needs to build training database/s, she is asking the following questions: 1. use Sybase or Oracle as the database server? We have some projects using Sybase databases, and old training database is on Sybase. 2. build the database on Unix vs NT platform? 3. She wants each trainee has his/her own database(!!!), since she doesn't want one use to see other user's data. And she said in Sybase it's really easy to do this, she has a script that can create multiple databases. Is it doable (please give some tip or script), or is it necessary ??? Any idea will be greatly appreciated!!! Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
import and strange PK violation error ???
All, I'm import from a dmp file. I already disable PK, FK on all the tables, but when I import I still got: unique constraint (ICSSOWNER.PK_ACCOUNT_PROFILE) and PK_ACCOUNT_PROFILE is already disabled. Any idea? Thanks. Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
??? import and strange PK violation error ???
In addition to my previous mail: I'm import from a dmp file. I already disable PK, FK on all the tables, but when I import I still got: unique constraint (ICSSOWNER.PK_ACCOUNT_PROFILE) and PK_ACCOUNT_PROFILE is already disabled. Any idea? *** I can manually insert the rows and commits fine, but got this annoying pk violation while importing. Note: forwarded message attached. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ All, I'm import from a dmp file. I already disable PK, FK on all the tables, but when I import I still got: unique constraint (ICSSOWNER.PK_ACCOUNT_PROFILE) and PK_ACCOUNT_PROFILE is already disabled. Any idea? Thanks. Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/
Re: row count in table ?
thank you. --- "Dennis M. Heisler" [EMAIL PROTECTED] wrote: Analyze the tables, then look at num_rows in dba_tables. Andrea Oracle wrote: All, Is there an easy way to find out how many rows are there is each table for a schema? Thank you. Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: Dennis M. Heisler 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). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
row count in table ?
All, Is there an easy way to find out how many rows are there is each table for a schema? Thank you. Andrea __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
How to get rid off file permanently?
Hi all, I need to permanently get rid off some files from the database. I did this: 1. alter database datafile '/orafs/ora1/oradata/LUCP/users02.dbf' offline drop 2. rm the file from physical directory After I shutdown and restart the db, I still see the file in dba_data_files table. So how to tell the control file that the file is already gone? Thank you. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).
syntax for trigger
Hi all, How to find out the whole syntax for a trigger? The dba/all/user_source view don't have text for trigger. The trigger_body column in All_triggers view doesn't show all the syntax. Thanks a lot. Andrea __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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).