How to record at SqlServer using Oracle
Hi friends How can i do for write data in SqlServer database using Oracle. Need I run the process in sqlserver or in Oracle ? What is necessary for it ? database link ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Resource for index
Dear Stephane, At first, my apologize by the word Resource, it was the first word that I found out and wrote it. The case is that this command +0 , you can put it in the sentence line of where and the sintaxe is correct. Oracle executes the statment and don't gives error message. My doubt is : What this +0 does in the sql ? Imagine a column unindexed that you can not create a index, because it will do a bad performance in all the system, you can use +0 that it will break the index . It is what i eard. But i am searching about this +0 and until now, i didn't find out nothing about it. For me it doesn't exist. Did you do a test ? You can put it at the statment that will run , normaly. And more, if you to use explain plan the table (unindexed) will have a FULL TABLE SCAN. So, I ask : What is this +0 ? Resource or not , it is my hard doubt. Regards Eriovaldo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, October 13, 2003 4:04 PM Friends : I have a part of statment as below : select column1 from table1 where column1 = v_parameter; The column1 is not indexed, so the table full scan will be executed. Right? Well, I would like to know if anyone knows the resource : select column1 from table1 where column1 = v_parameter +0 What does it mean (+0). What kind of resource is it ? What does it do ? Best Regards Eriovaldo Eriovaldo, Don't understand too well what you mean by 'resource'. One of the most cunning performance tips of yore was to either concatenate an empty string to a string or date column or add a zero to a number column to prevent the RBO from using an index on this column (BTW it's a trick which can still be useful at times) when this index was known to be not very selective. Quite obviously, applying this to the constant part of an equality is totally pointless. And since the column is unindexed, it wouldn't have much utility either on the other side of the equality. Another case of ill-digested and ill-understood trick. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eriovaldo Andrietta 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 Entry
Hi Friends, I would like to know what is Data Entry in Oracle environment. Is it a tool ? Is it a language ? What kind or resource or tool is it ? Tks Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: STATSPACK
Dennis, No, I don't want more information now. I am not using it. I has just willing to know what is this. Be sure , that when i will use it, i will post questions here. Thanks a lot. Eriovaldo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 2:58 PM Eriovaldo - STATSPACK is Oracle's new utility to replace utlbstat/utlestat. Available in Oracle8i and upwards. If you are using Oracle8i or Oracle9i, you should learn about STATSPACK. It is included in your Oracle, so you may as well make use of it. Let me know if you are interested in more information. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 11, 2002 10:15 AM To: Multiple recipients of list ORACLE-L Friends : What does it mean : STATSPACK ? Regards Eriovaldo - Original Message - To: Multiple mailto:[EMAIL PROTECTED] recipients of list ORACLE-L Sent: Monday, December 09, 2002 3:24 PM Wow that does sound way cool Thanks for sending this Barbara. -Original Message- Sent: Monday, December 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Seema: Head to Tim Gorman's site ( www.evdbt.com http://www.evdbt.com http://www.evdbt.com http://www.evdbt.com ) and find his sppurpkg.sql download. It uses dbms_jobs to run with a purge each set number of days. It's really slick. Barb Seema Singh [EMAIL PROTECTED] wrote: Hi How to clean all old STATSPACK data? Thx -Seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com 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 comm! and for other information (like subscribing). _ Do you Yahoo!? Yahoo! Mail Plus http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com - Powerful. Affordable. Sign up now http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: STATSPACK
Title: RE: STATSPACK Friends : What does it mean :STATSPACK ? Regards Eriovaldo - Original Message - From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Monday, December 09, 2002 3:24 PM Subject: RE: STATSPACK Wow that does sound way cool Thanks for sending this Barbara. -Original Message- From: Barbara Baker [SMTP:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: Re: STATSPACK Seema: Head to Tim Gorman's site ( www.evdbt.com http://www.evdbt.com) and find his sppurpkg.sql download. It uses dbms_jobs to run with a purge each set number of days. It's really slick. Barb Seema Singh [EMAIL PROTECTED] wrote: HiHow to clean all old STATSPACK data?Thx-Seema_STOP MORE SPAM with the new MSN 8 and get 2 months FREE*http://join.msn.com/?page=features/junkmail--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Seema SinghINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP comm! and for other information (like subscribing). _Do you Yahoo!?Yahoo! Mail Plus http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com - Powerful. Affordable. Sign up now http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com
Monitoring Database by Unix
Friends : Do you have scripts ready for : 1.) to see usage memory by database on unix ? 2.) to see usage memory by schema inside database? 3.) to see usage I/O by session inside database ? 4.) to find out how long a session is not being used, and treats it as a non used or lost session , that is using memory unnecessary 5) to see the load of the machine 6.) explanation about itens showed in the top comand ? what can i look at this comand ? what is the main item that dba needs to see ? In general , i would like to monitor the machine with database server . Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Scripts for creating Tables/schema's
Friend : You can usethe option INDEXFILE of imp program. INDEXFILE=c:\your_name.txt Ity will generate the script. I am not sure if it runs with exp, may be ... I had used with imp. Regards Eriovaldo - Original Message - From: Santosh Varma To: Multiple recipients of list ORACLE-L Sent: Friday, October 25, 2002 5:03 AM Subject: Scripts for creating Tables/schema's i wanted a script which contains the create table/schema's for a existing database. How to get this script ? any utitlity or which option to be selected for achieving this after i install Oralce ? i am using oracle 8.1.7. Thanks and regards,Santosh
Script for Import 29000000 lines in background and to create index.
Friends : I have a situation : I need to import file wiht 29.000.000 lines and after it i would like to create a index in background on unix. Does anyone have some example off shell script that does it using nohup and ? My idea is to call just one time and to run all operations, like that : 1.) imp user/passwd file=file.dmp fromuser=user1 touser=user2 rows=y log=log1; 2.) create index ind1 on table1 (col1, col2) tablespace tbs1; My doubt is : How to write a shell script using nohup and and that the second item wait the first finish. Regards Eriovaldo Andrietta [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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 do for point at the first line of openned cursor
Hi Friends Is there any way to point at the first line of openned cursor ? For example : After apply the for ... loop at the finished i would like to set the first line , but i don't want to open it again Regards Eriovaldo Andrietta [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DB link problem
Friend : Once time ago, i had a problem with remote connection. So, i had solved it putting the ip of other machine in the file called by hosts. This file is located in the o OS directory. I were using sqlplus with client installed in the station. You can try to connect using the server database (sqlplus) and realize what happen ? I hope it helps. Regards Eriovaldo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 09, 2002 1:28 AM Dear All, i have created a DB link to remote database its working perfectly with some tables of remote DB but fails with some tables.. 16:27:08 SQL select * from zone_mst@arvind; select * from zone_mst@arvind * ERROR at line 1: ORA-22804: remote operations not permitted on object tables or user-defined type columns. Regards Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arvind Kumar 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: Eriovaldo Andrietta 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 learn XML ?
Hi friends : How can i do for learn XML ? Does anyone know some good site that teaches it for us ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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 Centers
Hi Friends : I work at the company that is looking for a Data Center. The needs is to put a product that run in internet, (E-procurement). If you know some internet address , please send to me. Nowadays the product is developed in Java/Oracle/Linux and i think that others options will be also analyzed. Regards Eriovaldo [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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).
MTS and Dedicated Server
Hi friends : I just finished to install my database with shared server option, so i have some parameters like mts_ My question : 1.) How can I do for to take out this option and put the database in Dedicated Mode ? 2.) What can I do for use two kinds of options simultaneity: Shared and Dedicated ? I think that i need jut to take out the parameters with mts_ at the begin and reestart the instance , right ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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).
Dedicated Server versus Shared Server
Hi friends : What is the diference between The instance in dedicated mode and shared mode ? Can I to change the mode from one to other ? What is the best way ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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: I need to change the instance name (to Dennis)
Yechiel : I will take a look at options. Well, for use replication i need to set some parameters, right? So, I didn't do it. It means that i don't use replication. but i will check others otpions. Thanks Regards Eriovaldo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 09, 2002 8:48 AM I looked at 9i options and I see that replication is not available with SE, only with EE. So, if you use replication you can not downgrade to SE from EE. ( replication is just an example). So you need to take a good look on the options difference between SE and EE to make sure you CAN downgrade. 9i option link: http://www.oracle.com/ip/deploy/database/oracle9i/index.html?packagingandopt ions.html Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 08, 2002 11:28 PM Yeachiel : We have 8.1.7 EE. Regards Cópia Yechiel Adar [EMAIL PROTECTED]: 8.1.6 SE or EE ? I meant that there are differences inside the same version between SE and EE. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 08, 2002 3:38 AM I am almost 100% sure. Because i have the application also running in the 8.1.6. Thanks Friends Eriovaldo - Original Message - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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). - Esta mensagem foi enviada por Siteplanet WebMail. http://webmail.siteplanet.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar 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: Eriovaldo Andrietta 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: I need to change the instance name (to Dennis)
Dennis : Thanks for your answer. Well, I need to downgrade my database, changing EE for SE, so ... The most problem is that the v$instance is used in the aplication. I saw in the metalink a document that helps to change the db_name and not the instance_name, understand.. so ... I thought to create the new one, with the new name and migrate to it and after it to change the name to the old one... Like that, i shouldn't change the application . But i hope that the best way is : Deinstall and install the new version. And to migrate it fully. Right ? Regards Eriovaldo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 06, 2002 11:53 AM Eriovaldo - Often the lot of a DBA is to balance value and risk. Here, you must ask yourself - what is the value of retaining the same instance name, and what are the risks to my production environment? If you perceive the value to be high and the risks low, then go for it. But often (especially after you've been stung a few times) it seems that the value wasn't so great after all. How long can you have your production site down? What happens if something goes wrong and you have them down quite a bit longer than you estimated? You can lower the risk to your production site by creating the new instance (different name), and getting it all prepared before you take the production site down for the export. If most of your users access the instance via SQL*Net (Net8), you can put an alias there, so they don't have to change a thing. Of course, if your boss says do it or else, then the value/risk equation changes dramatically. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, May 05, 2002 5:18 AM To: Multiple recipients of list ORACLE-L Actualy, I am confused, because this is my production environment and I need to get sucess in this operation. It is necessary, and i would like to keep the old name of instance, because i will change the BD version. I think the best way is : 1.) backup the software and datafiles 2.) Export all the database 3.) Deinstanll the old software 4.) Install the new version 5.) Create the instance with the old name 6.) Import the database but it will take a while. I am looking for a fast way , Understand ? Thanks Regards Eriovaldo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, May 04, 2002 8:03 PM Its actually the easiest part. However, I don't want to miss a step so you best running off to Metalink. They actually have a note out there on how to do it. Not quite up to date for 9i but close. You need to shutdown your database, change your oracle sid, rename your init, if using an i version change the instance name and if desired the service name. Hum, me thinks that's it. I may be missing something though. I feel like I am missing something. However, the moral of the story is that its quite easy and I have done it a couple of times. You need to make a decision on what to do with your directories structures if you are using the $ORACLE_BASE/admin/sid structure. There is no technical reason to change it except for your own sanity. -Original Message- Andrietta Sent: Saturday, May 04, 2002 12:23 PM To: Multiple recipients of list ORACLE-L Friends : I need to change the instance name. For example it is : DEVELOP and I need to put DEVELOPER. I know how to change the database name , but not the instance name .. Any idea ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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: Kimberly Smith 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
Re: I need to change the instance name
Actualy, I am confused, because this is my production environment and I need to get sucess in this operation. It is necessary, and i would like to keep the old name of instance, because i will change the BD version. I think the best way is : 1.) backup the software and datafiles 2.) Export all the database 3.) Deinstanll the old software 4.) Install the new version 5.) Create the instance with the old name 6.) Import the database but it will take a while. I am looking for a fast way , Understand ? Thanks Regards Eriovaldo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, May 04, 2002 8:03 PM Its actually the easiest part. However, I don't want to miss a step so you best running off to Metalink. They actually have a note out there on how to do it. Not quite up to date for 9i but close. You need to shutdown your database, change your oracle sid, rename your init, if using an i version change the instance name and if desired the service name. Hum, me thinks that's it. I may be missing something though. I feel like I am missing something. However, the moral of the story is that its quite easy and I have done it a couple of times. You need to make a decision on what to do with your directories structures if you are using the $ORACLE_BASE/admin/sid structure. There is no technical reason to change it except for your own sanity. -Original Message- Andrietta Sent: Saturday, May 04, 2002 12:23 PM To: Multiple recipients of list ORACLE-L Friends : I need to change the instance name. For example it is : DEVELOP and I need to put DEVELOPER. I know how to change the database name , but not the instance name .. Any idea ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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: Kimberly Smith 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: Eriovaldo Andrietta 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).
I need to change the instance name
Friends : I need to change the instance name. For example it is : DEVELOP and I need to put DEVELOPER. I know how to change the database name , but not the instance name .. Any idea ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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: sqlldr
ok Yechiel. Thanks for the answer. Regards Eriovaldo - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Sunday, April 28, 2002 6:43 AM Subject: Re: sqlldr Hello I do not have experience with 9i and 8i. One paper that I downloaded from OTN (I think) is: Install and Configure the Oracle 9i Platform. This paper starts with preinstall task: Remove installed oracle databases and removed all installed oracle software from the machine. I believe this is just to simplify the new install. We have a NT server with oracle 7.3.4 and 8.1.6 installed in two homes and there are no problems. Yechiel Adar Mehish - Original Message - From: Eriovaldo Andrietta To: Multiple recipients of list ORACLE-L Sent: Sunday, April 28, 2002 2:13 AM Subject: Re: sqlldr HI Yechiel : How can i to install two versions of Oracle in the same server , like : Oracle 8i and Oracle 9i, in oracle_home different. Is it possible ? Regards Eriovaldo - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Saturday, April 27, 2002 8:18 PM Subject: Re: sqlldr Hello Stephen Thanks for the link. The article is very illuminating. As we have some loader tuning to do I thank you for sharing the knowledge. Yechiel Adar Mehish - Original Message - From: Stephen Andert To: Multiple recipients of list ORACLE-L Sent: Friday, April 26, 2002 6:43 PM Subject: Re: sqlldr Ravi, To the best of my knowledge, there is no limitation on the number of records that can be loaded at a time other than the size of your rollback segments. I have loaded 10's of millions of rows in a single sqlldr job by setting some parameters. There are defaults that work, but don't perform very well. To determine appropriate settings, you may want to read an article I wrote for O'Reilly Associates (located athttp://oracle.oreilly.com/news/oraclesqlload_0401.html)which gives the step-by-step directions on setting2 of the key parameters (BINDSIZE and ROWS). It's a pretty easy thing to do, but without knowing you data, the only advice I could give is that DIRECT is the best quick tuning fix if you can. If you are going to be doing any serious data loading with SQL*Loader, Jonathan's book Oracle SQL*Loader: The Definitive Guidewould be a good investment. HTH Stephen [EMAIL PROTECTED] 04/25/02 10:13PM i belive there is a limitation on the number of records that can be loadedfrom sqlldr at a time based on the bind array and rows default parameter.if i have a data file with more than 5000records(don't know the exactnumber) that needs to be imported using sqlldrwhat is the value i need to set for the "rows" and/or "bind array" for me toload the records to the table at one attempt.thanksravi-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ravindra B INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: sqlldr
HI Yechiel : How can i to install two versions of Oracle in the same server , like : Oracle 8i and Oracle 9i, in oracle_home different. Is it possible ? Regards Eriovaldo - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Saturday, April 27, 2002 8:18 PM Subject: Re: sqlldr Hello Stephen Thanks for the link. The article is very illuminating. As we have some loader tuning to do I thank you for sharing the knowledge. Yechiel Adar Mehish - Original Message - From: Stephen Andert To: Multiple recipients of list ORACLE-L Sent: Friday, April 26, 2002 6:43 PM Subject: Re: sqlldr Ravi, To the best of my knowledge, there is no limitation on the number of records that can be loaded at a time other than the size of your rollback segments. I have loaded 10's of millions of rows in a single sqlldr job by setting some parameters. There are defaults that work, but don't perform very well. To determine appropriate settings, you may want to read an article I wrote for O'Reilly Associates (located athttp://oracle.oreilly.com/news/oraclesqlload_0401.html)which gives the step-by-step directions on setting2 of the key parameters (BINDSIZE and ROWS). It's a pretty easy thing to do, but without knowing you data, the only advice I could give is that DIRECT is the best quick tuning fix if you can. If you are going to be doing any serious data loading with SQL*Loader, Jonathan's book Oracle SQL*Loader: The Definitive Guidewould be a good investment. HTH Stephen [EMAIL PROTECTED] 04/25/02 10:13PM i belive there is a limitation on the number of records that can be loadedfrom sqlldr at a time based on the bind array and rows default parameter.if i have a data file with more than 5000records(don't know the exactnumber) that needs to be imported using sqlldrwhat is the value i need to set for the "rows" and/or "bind array" for me toload the records to the table at one attempt.thanksravi-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ravindra B INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: char vs. varchar2
Friend : In my opinion, if you will use the ltrim(rtrim(column_char)) , i hope you solve the problem. Am i wrong ? Eriovaldo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 22, 2002 7:12 PM Is there any overhead (ie. internal conversion) in comparing a char to a varchar2? We found an instance where a primary key in one table is defined as char(2) and the foreign key referencing it from another table is varchar2(2). We are going to change it, but I'm curious what, if anything, happens when resolving the integrity? Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa 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: Eriovaldo Andrietta 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: Patch Install (8.1.7.3) and oraInventory
Hi Glenn : I just finished to do it today. I just deleted the temp files, and after it the Universal Installer showed for me the list of products. Regards Eriovaldo - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, April 22, 2002 5:51 PM I am trying to install the 8.1.7.3 upgrade patch. Unfortunately, somewhere down the road I have lost my oraInventory directory. The installer says 'There are no patches to be applied. Metalink says that the only way to get your oraInventory back is to reinstall the current version of Oracle and all patches. Does anyone know of a way to get the patch to install without the inventory history? Or a way to rebuild the oraInventory directory? This is a cloned database and I already tried copying the oraInventory directory from another instance, but the files have the installation directory hardcoded and the oraInventory files are binary so I can't change them. If all else fails, I will reinstall Oracle. But that leads to another question. I want to install the same components that are installed in another instance (that it was cloned from). Is there a way to get a listing of installed components? I ran the installer on the original instance and selected 'Installed Products...' to get a listing, but when I saved it, it gave me a ton of information, most of which was duplicates. How do I weed through that listing? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis 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: Eriovaldo Andrietta 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).
Describe Command is Slow
HI Friends : I am executing DESCRIBE TABLE_NAME and it is slow. The indicator of tuning of data dictionary is around 0,9. What is happening ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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).
Downgrade Oracle 8.1.7 Enterprise to 8.1.7 Standard
Friends : I need to downgrade Oracle version 8.1.7 EE to 8.1.7 SE. Did anyone do it ? What is the best way ? I don't use features of Enterprise. To install again , recreate the instance and export / import the data ? To use some script that do it ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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).
EDI Translator
Hi Friends : Does anyone use EDI Translator ? Is it a toool of Oracle's ERP ? Does anyone use translation from EDIFACT using pl/sql ? What resource is used for it ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Nested Table
Hi friends : I am trying to use nested table and i am not getting success. Does anyone use it for insert in a nested table (data collection) instead to create a relational table to put details there ? How is the better way to use it ? Can I to export and import this table in the future ? []s Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta 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 Advanced Queuing
HI Friends : What is the basic function of Oracle Advanced Queuing ? How does it work ? Regards Eriovaldo
Select in TABLE OF
Hi Friends : I have the follow situation : I have a table and i did select getting data. After it i used the data in a cursor and put it in a type variable TABLE OF varchar(4000) , for example . Now, I would like to do select in this table of and pass it as parameter out refcursor . Is it possible ? I know that i can pass the refcursor from a relational table. Regards Eriovaldo