merge command ???
Hi, for Merge command, how to specify if matched, not to do anything, I tried NULL, not working. Thank you! MERGE INTO caption c3 USING [EMAIL PROTECTED] c1 ON (c3.caption_id = c1.caption_id) WHEN MATCHED THEN NULL -- don't need to do anything when matched! WHEN NOT MATCHED THEN INSERT (c3.CAPTION_ID, c3.CAPTION_NAME, c3.VISIBILITY_ID, c3.MOD_DATE, c3.MOD_USER) VALUES (c1.CAPTION_ID, c1.CAPTION_NAME, c1.VISIBILITY_ID, c1.MOD_DATE, c1.MOD_USER); __ Do you Yahoo!? Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy 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).
data warehouse vs regular database??
Hi all, I have been working with Oracle 92. I have no experience with Oracle Warehouse. In my current company, I was told the database is a warehouse. I can connect to it using sql plus or pl/sql developer. The "warehouse" looks the same as the database I worked with before. How do I tell if a database is a warehouse or just a regular database. What's the big difference between the two? Could someone send me some link about data warehouse? Thank you! Janet __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy 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).
Why compiling pkg hangs???
Hi all, Our app is written using pl/sql's packages. When I tried to display one form and it runs forever. So I closed the form, and changed the sql in the package that generates the form, and recompiled the pkg, and the recompiling hangs. I checked the database, there is no locking there. What shall I do? (Oracle9i on Linux RedHat, 9iAS.) Thanks. Janet __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy 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).
9i new feature on-line doc ???
Hi all, Does anyone know some on-line doc for 9i new feature? Thank you! Janet __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy 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).
replace ' with '' ???
Hi, I apologize it might be a wrong place to post the question, but since it's the only list I know ... You know when you insert a'b into db, you got to change it to a''b, our value is from jsp, so I have this request.getParameter("p_location_name").toUpperCase().trim(), in case there is ' in it, I need to replace it with ''. How to do this in jsp, I tried string.replace('\'','\'\''), replace("'","''"), replace("\'","\'\'"), all sorts stuff and doesn't work. We are using jdk 1.3.1. Any suggestion?? Thank you! Janet __ 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: Janet Linsy 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).
interview site??
Hi, Could you send me some interview sites (question and answer) for PL/SQL or javascript or jsp or java. Thank you! Janet __ 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: Janet Linsy 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).
update statement ???
Hi all, I need to update a column (brch_name) to be without (NO PHONE #S) string. So 3954 will be Denver, 3955 will be Golden, and 3963 will be LOVELAND 29TH, etc. How to write this update statement??? Thank you! 1* select brch_id, brch_name from cli_branches where upper(brch_name) like '%PHONE%' SQL> / BRCH_ID BRCH_NAME -- -- 3954 DENVER (NO PHONE #S) 3955 GOLDEN (NO PHONE #S) 3956 ENGLEWOOD (NO PHONE #S) 3957 LITTLETON (NO PHONE #S) 3958 CHARLOTTE (NO PHONE #S) 3959 S LEMAY (NO PHONE #S) 3960 HARMONY ROAD (NO PHONE #S) 3961 ENGLEWOOD (NO PHONE #S) 3962 LOVELAND (NO PHONE #S) 3963 LOVELAND 29TH (NO PHONE #S) 3964 DENVER (NO PHONE #S) __ 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: Janet Linsy 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).
function based index help ??
Hi all, I have a table like this, both cols are Nullable. SQL> desc test Name Type - - STATUSCHAR(1) (could be A or D) IDNUMBER I'd like to build a unique index on column ID when the status='A', how to create this function based index? Thank you! Janet __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy 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).
strange problem ??!!
Hi, I got a very strange problem (9.2 on Linux Red Had, 9iAS). I have a package which works fine, I added a new procedure in that package, if the procedure's name starts with order_, (the pkg has some procedure starts with order) the pkg compiles, and app runs fine. if I rename it something else, pkg compiles, but when runs the app, I got: [Thu Jun 12 14:52:52 2003] [error] mod_plsql: /prv/html_rpt.LIS_count HTTP-404 html_rpt.LIS_count: SIGNATURE (parameter names) MISMATCH VARIABLES IN FORM NOT IN PROCEDURE: NON-DEFAULT VARIABLES IN PROCEDURE NOT IN FORM: NUM_ENTRIES,NAME_ARRAY,VALUE_ARRAY,RESERVED I renamed the LIS_count into order_LIS_count, (change in header, body and calling procedure) no parameters changes at all, and app runs! ??? __ 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: Janet Linsy 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).
java script and pl/sql again ???
Hi, Thank you to all those answering my java script question. As I said, all the html and java script are generated by pl/sql package. I'd like to know can the onClick method below call a pl/sql procedure? If it cann't, I suppose onClick needs to call a java script function first, and in that java script function, how to call a pl/sql procedure ??? (wl is a function used to generate html) Package pkgSth AS ... wl('; ... End; Thank you! Janet __ 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: Janet Linsy 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).
pl/sql and java script ???
Hi, Our app is strange. :-( We use pl/sql(9i) package to create all the html and java script. I have two drop down boxes on a form, the values for the second box changes dynamically depends on the value of the first box. The values for the boxes are from cursors written in pl/sql. We currently resubmit the form after the first box is clicked. How to handle this without resubmitting the form? How to let java script function read data from pl/sql cursors?? PS: If you know an email list or metalink like resource for J2EE and/or Java script, please let me know!!! Thank you in advance. Janet __ 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: Janet Linsy 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).
show errors doesn't show anything ???
Hi, I have 9i on Linux Red Hat 2.4.9. A package is invalid after compiling. I did a show errors but nothing shows. How do I see where the error is ?? SQL> alter package prv_admin compile; Warning: Package altered with compilation errors. SQL> show errors; No errors. Thank you in advance! Janet __ 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: Janet Linsy 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).
ora 12516 ???
Hi, My database 9.2.0 is on Linux Red Hat, and I use SQL plus 815 client to connect to it. It works fine since I've used them (that's 3 weeks), and today I got ora 12516 while using sqlplus to connect to the database. cprsrv15 [oracle]: oerr ora 12516 12516, 0, "TNS:listener could not find available handler with matching protocol stack" If I log into Linux, and try to connect to the db there, the connection is fine. Any idea? Also how to find out Linux version? Thank you in advance! Janet __ 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: Janet Linsy 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).
AT doesn't run and xcopy question ???
Hi all, Thank you for those sending me AT examples. I scheduled a job successfully, but it doesn't run at the scheduled time. The status shows Error. Do I need to setup something first? (Windows 2000) By the way, I try to run a backup.bat. I have a,b,c subdirectories under D:, and I'd like to backup a,b under e:\backup directory. How to let the script create a and b subdirectories under e:\backup, and copy over the files. Now I manually create a and b under e:\backup. Thank you in advance. Janet __ 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: Janet Linsy 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).
AT command ??
Hi all, Can anyone give me some examples of AT command in windows? Thank you! Janet __ 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: Janet Linsy 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).
Ewrin question ??
Hi all, I have couple of questions about ERWIN. -- I need to reverse engineer for just one schema. I specify the login name/pwd for that schema, but ERWIN generates charts for objects do NOT belong to that schema too! How do I get charts for a specific schema only? -- When connect to the db, Erwin asks about target server, ef: ODBC, Oracle, Sybase, etc. I can connect to the db through ODBC, but cann't connect using Oracle directly. Why ? Really appreciate any thoughts. Thank you in advance. Janet __ 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: Janet Linsy 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).
database relationship chart ??
Hi, I got the Erwin(3.5.2) working for generate charts for one schema. Thank you for all the help. The chart doesn't show PK, FK relationship. There is on lines between entities to show that they are related. How does Erwin do that? Or maybe is there other tools that can generate db chart with relations? Thanks. Janet __ 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: Janet Linsy 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 send/receive email through pl/sql ??
Hi, I have the following code. it compiles fine and runs successfully. But when I checked email in [EMAIL PROTECTED], I didn't get any mail. I'm testing on the same machine (win2000, 817). Anybody knows why? Thank you in advance. create or replace PROCEDURE send_test_message IS mailhostVARCHAR2(64) := 'localhost'; sender VARCHAR2(64) := '[EMAIL PROTECTED]'; recipient VARCHAR2(64) := '[EMAIL PROTECTED]'; mail_conn utl_smtp.connection; BEGIN mail_conn := utl_smtp.open_connection(mailhost, 25); utl_smtp.helo(mail_conn, mailhost); utl_smtp.mail(mail_conn, sender); utl_smtp.rcpt(mail_conn, recipient); -- If we had the message in a single string, we could collapse -- open_data(), write_data(), and close_data() into a single call to data(). utl_smtp.open_data(mail_conn); utl_smtp.write_data(mail_conn, 'This is a test message.' || chr(13)); utl_smtp.write_data(mail_conn, 'This is line 2.' || chr(13)); utl_smtp.close_data(mail_conn); utl_smtp.quit(mail_conn); EXCEPTION WHEN OTHERS THEN -- Insert error-handling code here NULL; END; / __ 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: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle package that can generate HTML content ???
Hi all, I saw some Oracle packages that can generate HTML content. The package looks like ftpk.c (I don't remember the exact name). Does anyone know what those packages are, and where to find documents? Thanks, Janet __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle DBA vs JAVA programmer???
Hi all, I need your idea. I got laid off as an Oracle DBA (3 yrs experience), and it's hard to find a DBA position here(I'm in Colorado). I had couple of years experience programming (3 yrs) in VB, and currently learning JAVA. I'd like to know is JAVA market still hot? (I can relocate to New Jersey, any memeber in New Jersey? how is the market over there, for Oracle DBA or JAVA programmer?) What do you think which position is better, Oracle DBA or Java programmer? Based on compensation, workload, market demand, etc, etc ... Thanks a lot! Janet __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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).
generate insert statement ???
Hi all, I need to generate insert statements for a given table. For example ACCOUNTING_TRANSACTION_TYPE table has 300 rows, and I need to generate a sql like the following: INSERT INTO ACCOUNTING_TRANSACTION_TYPE (ACCT_TRAN_TYP_CD, ACCT_TRAN_TYP_NM, GL_ACCT_TYP_CD, ACCT_TRAN_TYP_GL_IND, ACCT_TRAN_TYP_VOID_IND) VALUES ('wrtn_prem', 'Written Premium', '109200_401600', 'y', 'n'); insert blocks for the rest rows Are there any easy way to handle this? Thank you in advance! Janet __ Yahoo! - We Remember 9-11: A tribute to the more than 3,000 lives lost http://dir.remember.yahoo.com/tribute -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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 certain character from a string ???
Hi all, How to get rid off certain character from a string. For example, I have string 'WC_89_06_03', what's an easy way to get 'WC890603' out, is there a function? Thank you in advance! Janet __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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).
couple of questions ???
Hi all, I have couple of questions, 817 on NT. 1. There is an invalid SP, my collegue did a Show Errors in SQL Plus, it shows the error; but I did the same thing in my Sql Plus, I got "No errors". Is there any settings I need to change? 2. There is a valid SP, when I did a Alter procedure p_Name compile. It just hangs. It was compiling fine, now I added two lines (dbms_output stuff), and it just compiling forever. The code now has 7969 lines. Does that hit the limit? (I really doubt) Or are there any other reasons? Thanks, Janet __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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).
basic Unix question ???
Hi all, I have two questions. First, how to find out information about my unix box, like version, etc. In my box, I can use hostname to get the machine name. I remember there is a command called version, but I got "Ksh: version: not found." Any other useful commands to know about my machine? Actually when I use top, it also returns "ksh: top: not found." My second question is where does ksh usually reside, which value should I set for PATH. Thank you in advance. Janet __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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).
db doesn't show in OEM ???
Hi, I have two local databases on my machine. In OEM, after I find node, one db show but the other doesn't. How does that happen? OEM(2.2.0.0.0), Oracle 817 on Win2000. Thank you. Janet __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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).
standby database problem ???
Hi, I created a primary and a standby database. Both are 9i on Win2000, the same host. Everything was fine, except the last step: SQL> RECOVER MANAGED STANDBY DATABASE TIMEOUT 20; ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: 'C:\ORA_9I\ORADATA\SB1\DATAFILE\SYSTEM01.DBF' ORA-16016: archived log for thread 1 sequence# 7 unavailable I backed up the primary database when the archive was not on. I shutdown the db using shutdown immediate, and made a complete, cold back, I changed the primary database to archive log right after backup. Why the backup is not sufficient? Must the db in archivelog mode before making a backup? Thank you! Janet __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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: two listeners problem ???
Hi, After I issued lsnrctl start ORACL816, the 816 listener started, but the status shows "the listener supports no services." STATUS of the LISTENER Alias LISTENER816 Version TNSLSNR for Solaris: Version 8.1.6.0.0 - Production Start Date08-APR-2002 13:23:25 Uptime0 days 0 hr. 7 min. 16 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /export/apps/oracle/admin/product/8.1.6/network/admi listener.ora Listener Log File /export/apps/oracle/admin/product/8.1.6/network/log/ stener816.log The listener supports no services The command completed successfully I shutdown and restart the instance, it still cannot be registered in the listener. As a result, when I tried to log in, I got: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor Any suggestion? Much appreciated! Janet --- Oracle User <[EMAIL PROTECTED]> wrote: > > Did you try starting them as start . > In your case, it should > be > > start listener816/listener817 > > Also try giving 1525 instead of 1522. > You can also try to enable logging so you can find > out exactly what went > wrong. Did you get any errors while trying to start > the listener? > > Hope this helps. If not get back to me and I shall > help you. > > Rgds > Raj > > >From: Janet Linsy <[EMAIL PROTECTED]> > >To: "LazyDBA.com Discussion" > <[EMAIL PROTECTED]> > >Subject: two listeners problem ??? > >Date: Fri, 5 Apr 2002 22:09:15 -0800 (PST) > > > >Hi, > > > >I have two databases ORCL817 and ORCL816 in version > >817, 816 on the same machine Sun 5.7. I'd like to > >configure seperate listener for each database. I > used > >different port, listener name (1521 and LISTENER817 > >for ORCL817 , 1522 and LISTENER816 for ORCL816), > but > >somehow the listener on 1522 cannot be started. > >Why??? > > > >Here is the listener.ora and tnsnames.ora for both > >database: > > > >listener.ora for 816 > >= > >LISTENER816 = > > (DESCRIPTION_LIST = > > (DESCRIPTION = > > (ADDRESS_LIST = > > (ADDRESS = (PROTOCOL = TCP)(HOST = > >gatech-denver1)(PORT = 1522)) > > ) > > ) > > (DESCRIPTION = > > (PROTOCOL_STACK = > > (PRESENTATION = GIOP) > > (SESSION = RAW) > > ) > > (ADDRESS = (PROTOCOL = TCP)(HOST = > >gatech-denver1)(PORT = 2481)) > > ) > > ) > > > >SID_LIST_LISTENER = > > (SID_LIST = > > (SID_DESC = > > (GLOBAL_DBNAME = ORCL816) > > (ORACLE_HOME = > >/export/apps/oracle/admin/product/8.1.6) > > (SID_NAME = ORCL816) > > ) > > > >tnsnames.ora for 816 > >= > >ORCL816 = > > (DESCRIPTION = > > (ADDRESS_LIST = > > (ADDRESS = (PROTOCOL = TCP)(HOST = > >gatech-denver1)(PORT = 1522)) > > ) > > (CONNECT_DATA = > > (SERVICE_NAME = ORCL816) > > ) > > ) > > > >listener.ora for 817 > >= > >LISTENER817 = > > (DESCRIPTION_LIST = > > (DESCRIPTION = > > (ADDRESS_LIST = > > (ADDRESS = (PROTOCOL = TCP)(HOST = > >gatech-denver1)(PORT = 1521)) > > ) > > ) > > (DESCRIPTION = > > (PROTOCOL_STACK = > > (PRESENTATION = GIOP) > > (SESSION = RAW) > > ) > > (ADDRESS = (PROTOCOL = TCP)(HOST = > >gatech-denver1)(PORT = 2481)) > > ) > > ) > > > >SID_LIST_LISTENER = > > (SID_LIST = > > (SID_DESC = > > (GLOBAL_DBNAME = ORCL817) > > (ORACLE_HOME = > >/export/apps/oracle/admin/product/8.1.7) > > (SID_NAME = ORCL817) > > ) > > ) > > > >tnsnames.ora > >= > >ORCL817 = > > (DESCRIPTION = > > (ADDRESS_LIST = > > (ADDRESS = (PROTOCOL = TCP)(HOST = > >gatech-denver1)(PORT = 1521)) > > ) > > (CONNECT_DATA = > > (SERVICE_NAME = ORCL817) > > ) > > ) > > > >Anyone knows what went wrong? Thank you! > > > >Janet > > > >__ > >Do You Yahoo!? > >Yahoo! Tax Center - online filing with TurboTax > >http://taxes.yahoo.com/ > > > > > >Oracle docume
two listeners problem ???
Hi, I have two databases ORCL817 and ORCL816 in version 817, 816 on the same machine Sun 5.7. I'd like to configure seperate listener for each database. I used different port, listener name (1521 and LISTENER817 for ORCL817 , 1522 and LISTENER816 for ORCL816), but somehow the listener on 1522 cannot be started. Why??? Here is the listener.ora and tnsnames.ora for both database: listener.ora for 816 = LISTENER816 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = gatech-denver1)(PORT = 1522)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = gatech-denver1)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL816) (ORACLE_HOME = /export/apps/oracle/admin/product/8.1.6) (SID_NAME = ORCL816) ) tnsnames.ora for 816 = ORCL816 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = gatech-denver1)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL816) ) ) listener.ora for 817 = LISTENER817 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = gatech-denver1)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = gatech-denver1)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ORCL817) (ORACLE_HOME = /export/apps/oracle/admin/product/8.1.7) (SID_NAME = ORCL817) ) ) tnsnames.ora = ORCL817 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = gatech-denver1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL817) ) ) Anyone knows what went wrong? Thank you! Janet __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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).
Unix at command ???
Hi all, I'd like to run a file (r2) at 15:10 Apr 2. Below was what I did and I could not get out of at normally. /export/home/oracle/test$ at 15:10 Apr 2 at> r2 at> EOF at> at> at> EOT at> ^Z[19] + Stopped (SIGTSTP)at 15:10 Apr 2 I tried EOF according to the on-line doc, and also tried EOT, but none works. Finally I used Control Z to get out of at. I was out, but the script file didn't run. So what's the correct syntax to run the command at a specific date, time? Thank you! Janet __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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).
Could not create Tcl interpreter ???
Hi, I'm using OEM 9.0.1 on Win2000, after I submitted a job, I got error "Could not create Tcl interpreter". I read some metalink articles which don't help. Any solution? Much appreciated! Janet __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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).
table/index size ???
Hi, Does anyone know some scripts that can calculate table/index size, given the data block size, estimated number of rows, and table row size or index space per row? Acutally how to get table row size and index space per row? Thank you! Janet __ 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: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ora 600 in 6i tutorial install ???
Hi, I successfully installed designer 6i and configured a repository owner. I was trying to use the 6i for tutorial, so I imported the tutorial application system. In the middle of the import, I got ORA 600, see the attachment. Anybody knows what's going on? (oracle 9i on Win2000 Thank you! Janet __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ error.bmp Description: Windows bitmap
show prompt and accept variable in NT/2000 bat file???
Hi, How to show prompt and accept variable in NT/2000 bat file? I'd like to do something like: Inside bat file -- prompt The SID is: set ORACLE_SID=Input_Variable Thank you! Janet __ 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: Janet Linsy 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).
11i ???
Hi, Many thanks to those who answered my Oracle financial question. Also, is Oracle 11i downloadable somewhere? Any documentations available? Thank you! Janet __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Financial and/or manufacture
Hi, Did anyone know where to download Oracle Financial and/or manufacture sofeware? And where I can find documents for Financil and/or manufacture? I did searching in OTN, but didn't find them. Thank you! Janet __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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).
ROWNUM question ???
Hi, I have a table like this: SQL> select * from test; ID PRICE -- -- 1 1 1 3 1 4 1 5 1 6 I need to get the second largest price and I was using the ROWNUM. For the following statement, the result makes sense: SQL> select * from test where rownum < (select count(*) -1 from test); ID PRICE -- -- 1 1 2 3 3 4 But the rest twos didn't return anything: SQL> select * from test where rownum=(select count(*) -1 from test); -- supposed to return 5 ??? no rows selected SQL> select * from test where rownum > (select count(*) -1 from test); -- supposed to return 6 ??? no rows selected I vaguely remember that ROWNUM only works in < case, why is that? Thank you! __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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).
data modeling
Hi all, You know any good book, web site about data modeling? Thank you! Janet __ 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: Janet Linsy 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).
DBA position in Denver???
Hi all, Does anyone know some Oracle DBA openning in Denver and vincinity? I'm seriously looking for a job. Thank you! Janet __ 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: Janet Linsy 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).
update query??? HELP!!!
Hi all, How to do this query, I have three tables: SERVICE_LOCATION a, SERVICE_LOC_AREA b, FRANCHISE_AREA c. The relationship between them is: a.SERVICE_LOCATION_ID = b.SERVICE_LOCATION_ID and b.FRANCHISE_ID = c.FRANCHISE_ID I need to update CENTRAL_OFFICE_CODE column in table SERVICE_LOCATION a, using a value selected from FRANCHISE_AREA c. a and c are related through b. update SERVICE_LOCATION set CENTRAL_OFFICE_CODE = (select FRANCHISE_NAME from FRANCHISE_AREA) where a.SERVICE_LOCATION_ID = b.SERVICE_LOCATION_ID and b.FRANCHISE_ID = c.FRANCHISE_ID) I don't know where to specify a, b, c tables. Thank you! Janet __ 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: Janet Linsy 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).
lock problem ???
Hi all, About the locking, could someone show me some script that shows who is locking others and who is being locked? And how to get the related locking or locked queries? Thank you! Janet __ 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: Janet Linsy 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).
protocol adapter error ???
Hi, I installed 815 client and server on NT 4.0. When I use svrmgrl to connect to the database, I got 12560 protocol adapter error. I already commented out all the entries in sqlnet.ora file. What should I do ??? Thank you! Janet __ 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: Janet Linsy 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 use a ref cursor inside a procedure ???
All, I have s sp, which return a refcursor. If I used in the following way, it looks fine: SQL> var k refcursor; SQL> exec lp_tagetversion (:k); SQL> print k; 4000 -- 4000 But how to use it inside a procedure? The following block compiles fine, I'd like the value in the refcursor k to be insert into kk, but I don't how to get the value out. Also k is defined using a precompiled package, which works fine. If don't use that package, how to declare k as a ref cursor? declare k GLOBALPkg.RCT1; --> syntax see below kk number; begin lp_tagetversion (k); end; == CREATE or REPLACE PACKAGE GLOBALpkg AS TYPE RCT1 IS REF CURSOR; END; == Thank you! Janet __ 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: Janet Linsy 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).
file changed during tape backup ???
Hi all, I got the following from our Unix admin. Looks like control files for some database on many boxes got changed when being backed up on tape. (I suppose the backup on tape happened during mid-night) Does anybody know what the reason is, and why this only happened to control files? Thank you. -- Janet Following are Oracle warnings during the nightly tape backup: SNOW: snow:/orafs/ora1 save: Warning - `/orafs/ora1/oradata/GOLD404/control01.ctl' changed during save * snow:/orafs/ora1 save: Warning - `/orafs/ora1/oradata/AMY40/control01.ctl' changed during save SLEET: sleet:/orafs/ora1 save: Warning - `/orafs/ora1/oradata/oradata/TEST/control01.ctl' changed during save ICE: ice:/orafs/ora1 save: Warning - `/orafs/ora1/oradata/CP40TD/control01.ctl' changed during save TSUNAMI: * tsunami:/orafs save: Warning - `/orafs/ora1/oradata/AB406CNV/control01.ctl' changed during save * tsunami:/orafs save: Warning - `/orafs/ora2/oradata/AU406CNV/control02.ctl' changed during save * tsunami:/orafs save: Warning - `/orafs/ora3/oradata/AU406CNV/control03.ctl' changed during save __ 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: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle job ???
Hi all, I'm trying to find an Oracle DBA position in Denver. Does anybody know some openings, or do you know any good web sites? I checked dice and moster, not too many positions there. Thank you. Janet __ 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: Janet Linsy 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 in data tablespace ???
Hi all, I got bunch of indice reside in data tablespace. What's an easy, safy way to move them into index tablespace? Thank you. Janet __ 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: Janet Linsy 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).
listener question ??
Hi, when I do a lsnrctl status, there are two lines for one database. I checked listener.ora and tns.ora file, there is only one entry for the db in either file. Why it appears twice? PRODT612 has 1 service handler(s) PRODT612 has 1 service handler(s) Thank you. Janet __ 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: Janet Linsy 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).
svrmgrl, sqlplus question ???
Hi all, In sqlplus, you can use "col ... format ..." to make the output pretty. Can we format columns, make title in svrmgrl? Also I read that sqlplus can be used to mount, open database in 8i, but I don't see how. The db is 815 on Sun 5.6. Thank you! Janet __ 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: Janet Linsy 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).
sql hit, miss question ???
Hi all, I can get the library cache hit ratio and buffer hit ratio. Is there a way to tell which SQL got reparsed often and which SQL is using the existing parse tree, execution plan; Also which SQL got the least data from the buffer? Thank you! Janet __ 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: Janet Linsy 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).
transaction ???
Hi, all How to find the currently running transaction, including user, sql_text, etc? Do you have any scripts for monitoring, tuning transactions? Thank you! Janet __ 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: Janet Linsy 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, According to Oracle's doc, for a table > 1000 rows, if the query returns < 4% of the data, an index can be built. If I have a table, with ID 1,2, 3 return < 4% of the row, but ID 4, 5, 6 returns > 4% rows. Should I build an index on ID column? Also you know any general guildlines for building, not building indexes? OEM generates suggestions too, should I follow? Thanks you! Janet __ 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: Janet Linsy 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).
free up datafile space problem ???
Hi all, I have a data file of 2G and the free bytes is 1,413,079, the used bytes is only 683,829. I like to resize it. When I issue: alter database datafile '/orafs02/oradata/PV_A0725/ld_data05.dbf' resize 1000M, I got: ERROR at line 1: ORA-03297: file contains used data beyond requested RESIZE value But apparently, the file does NOT contain data beyond 1000M. Am I missing something? Thank you. Janet __ 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: Janet Linsy 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).
db check list ???
Hi all, Does anybody has a daily, weekly or monthly db performance check list? Scripts, paper will be really appreciated. Thank you. Janet __ 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: Janet Linsy 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).
dbassist ???
Hi, Does anybody has any luck running 815 dbassist to create a database on Sun 5.6? When I runned it, the first couple of pages work fine, then it stuck at creating database page, the status bar shows 0% for a long while. Eventually I killed it. I used this tool a while ago to save the creating db code in a script, but that script didn't run well either. Any suggestion? Janet __ 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: Janet Linsy 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).
send email through pl/sql ???
Hi all, Does anybody know how to send email through pl/sql? thank you. Janet __ 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: Janet Linsy 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).
File placement ?????
Hi, I generage a report.txt using utlbstat/utlestat, and use www.oraPerf.com to format it. In the formatted report, I saw that "Never split index and data files to different sets of disks". Does that mean I'd better put datafile and index file on the same disk? Since data file and index file are very large, many times I put them on different disks. Thank you for any advice. Janet __ 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: Janet Linsy 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).
Thanks, works! -- Re: dumn unix script question
Thank you Michael and Balaji. It works! I'm still in vb mind. vb is what I was doing. shell script is a mistery to me. --- Janet Linsy <[EMAIL PROTECTED]> wrote: > Hi all, > > This must be a really dumn question. :-< > > I have a script which doesn't work well, since it > doesn't recognize a subroutine. I compared my code > with other codes that work fine with sub function, > and > didn't see any difference. (at least look the same > style to me.) > > So I wrote a really small scipt to test the sub: > == > #!/bin/ksh > > echo "supposed to show hello below" > quick_test > > function quick_test { > echo "hello" > } > == > after I run it, I got: 1[3]: quick_test: not found. > > The box is: > Machine hardware: sun4u > OS version: 5.6 > > Don't know ksh version, how to know ksh version > really? > > Thanks! > > Janet > > > __ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail - > only $35 > a year! http://personal.mail.yahoo.com/ > > > Oracle documentation is here: > http://tahiti.oracle.com/pls/tahiti/tahiti.homepage > To unsubscribe: send a blank email to > [EMAIL PROTECTED] > To subscribe: send a blank email to > [EMAIL PROTECTED] > Visit the list archive: > http://www.LAZYDBA.com/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > By using this list you agree to these > terms:http://www.lazydba.com/legal.html > ______ 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: Janet Linsy 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).
dumn unix script question
Hi all, This must be a really dumn question. :-< I have a script which doesn't work well, since it doesn't recognize a subroutine. I compared my code with other codes that work fine with sub function, and didn't see any difference. (at least look the same style to me.) So I wrote a really small scipt to test the sub: == #!/bin/ksh echo "supposed to show hello below" quick_test function quick_test { echo "hello" } == after I run it, I got: 1[3]: quick_test: not found. The box is: Machine hardware: sun4u OS version: 5.6 Don't know ksh version, how to know ksh version really? Thanks! Janet __ 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: Janet Linsy 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).
thank you! -- RE: how to find out internal's password???
Yeah, that's the one !!! Thank all those who spent time on this. --- [EMAIL PROTECTED] wrote: > try this(on your dev box first): > 1.select instance_name from v$instance; > @command line, > 2.oradim80 -delete -sid > 3.oradim80 -new -sid (instance name> -intpwd > > > now you have a new password for internal. > > Sunil Nookala > Dell Corporation, > Austin, TX > > -Original Message- > Sent: Friday, May 25, 2001 1:07 PM > To: Multiple recipients of list ORACLE-L > > > This is in additional to my previous question about > how to turn off passowrd for internal: > > To try to turn off pwd for internal, I commented out > remote_login_passwordfile = exclusive in the init > file, now I need to shutdown and restart the > database. > I tried to login as internal to shutdown the db, > when > it askes for password, I tried a bunch things > including sys, manager, and they all failed. So I > used sqlplus system/pwd to login and do shutdown, > the > database is down, but now I cannot login to svrmgrl > to > startup the database, since I don't know internal's > password. So my question is how to find out > internal's password? Thanks a lot. > > Janet > > > __ > 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: Janet Linsy > 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: > 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: Janet Linsy 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 find out internal's password???
This is in additional to my previous question about how to turn off passowrd for internal: To try to turn off pwd for internal, I commented out remote_login_passwordfile = exclusive in the init file, now I need to shutdown and restart the database. I tried to login as internal to shutdown the db, when it askes for password, I tried a bunch things including sys, manager, and they all failed. So I used sqlplus system/pwd to login and do shutdown, the database is down, but now I cannot login to svrmgrl to startup the database, since I don't know internal's password. So my question is how to find out internal's password? Thanks a lot. Janet __ 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: Janet Linsy 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 turn off password prompt in NT???
Hi all, In Windows NT, how to disable the password prompt when login as internal through svrmgrl. I read an article in Metalink. The solution is for Unix which I don't see useful to my case. I checked all the sqlnet.ora files and all of them comment out SQLNET.AUTHENTICATION_SERVICES. Suggestion? Thanks, Janet __ 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: Janet Linsy 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).
memory question again ???
Hi, Thank you all for showing me how to check the Unix memory. Is there a way to show how much is used and how much is free? Thank you! Janet __ 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: Janet Linsy 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 check memory???
Hi all, since there are two many instances running on a box, we got: ERROR: ORA-12500: TNS:listener failed to start a dedicated server process After killing some instances, the connection works. So how to check the momery on a box, how to know when it's approaching limits? (I don't know too much about Unix, please throw any idea) Thanks a lot! Janet __ 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: Janet Linsy 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 interpret query plan
Hi all, I know how to generate the query plan but how to interplate the query plan, really? The only thing I know is if there is a FULL TABLE SCAN, that most probably is bad, need to build an index. However, if the query plan shows me something else, I don't know what to improve. For example, does the following look good??? (this is just one example, please throw me any idad you can think of. Thank you!) Query Plan --- SELECT STATEMENT cost= NESTED LOOPS OUTER NESTED LOOPS OUTER NESTED LOOPS OUTER NESTED LOOPS OUTER TABLE ACCESS BY INDEX ROWID CUSTOMER_ACCOUNT_CONTACTS INDEX RANGE SCAN CUSTOMER_ACCOUNT_CONTACTS_1 TABLE ACCESS BY INDEX ROWID PHONE INDEX UNIQUE SCAN PK_PHONE TABLE ACCESS BY INDEX ROWID PHONE INDEX UNIQUE SCAN PK_PHONE TABLE ACCESS BY INDEX ROWID PHONE INDEX UNIQUE SCAN PK_PHONE TABLE ACCESS BY INDEX ROWID PHONE INDEX UNIQUE SCAN PK_PHONE __ 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: Janet Linsy 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).
??? drop users' objects without dropping user
Hi, As you know, drop user ... cascade drops all the schema's object and the user, anybody knows a handy way to drop only the objects but keep the user? Also, when I export a schema from db1 and try to import into db2. Since the schema does NOT exist on db2, I got error "user not exist", so I have to create that user first before importing. Is there any way to import both the missing user and that user's objects? Thank you. Janet __ 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: Janet Linsy 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 visibility
Hi all, I got a table, when I do desc, delete, it works, but when I do truncate, I got error "table or view does not exist". Any idea? SQL> desc associate --> can see the table SQL> select count(*) from associate; --> works 1 SQL> truncate table associate; --> got error below truncate table associate * ERROR at line 1: ORA-00942: table or view does not exist SQL> SQL> delete associate; --> works SQL> Thanks Janet __ 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: Janet Linsy 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).