Re: Export data to dbf
if you are talking about dbase files you can do it via Excel. Excel has drivers both for oracle and for dbase files. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, March 06, 2003 7:43 AM Hello, I can't find out how to export some data (selected results) from oracle to dbf file. -- Best regards, Sergey mailto:[EMAIL PROTECTED] ICQ 160079606 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sergey V Dolgov 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: Yechiel Adar 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).
cant connect oracle after developer 9i instll
1.I installed Oracle 9i on a Windows XP platform. Had it create a default database. Successfully logged in. 2. I then installed the 9i developer suite. I am now getting the follow error in my trace file: Fatal NI connect error 12645, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleryantest)(A RGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID= ryantest)(CID=(PROGRAM=C:\ora9i\bin\oradim.exe)(HOST=RYAN-2LE36OFJCE)(USER=S YSTEM VERSION INFORMATION: TNS for 32-bit Windows: Version 9.0.1.3.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.0.1.3.0 - Production Time: 08-MAR-2003 21:32:28 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12645 TNS-12645: Parameter does not exist. ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Here is my sqlnet.ora file: # SQLNET.ORA Network Configuration File: C:\ora9i\network\admin\sqlnet.ora # Generated by Oracle configuration tools. SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) NAME.DEFAULT_ZONE = world NAMES.DEFAULT_DOMAIN = world SQLNET.EXPIRE_TIME = 15 SQLNET.ENCRYPTION_CLIENT = requested If I take out: SQLNET.ENCRYPTION_CLIENT = requested from SQLNET, I get the following error: ORA-01034: Oracle Not available ORA-27101: Shared Memory Realm not avaible I have checked services and my instance is started, along with my listener. I can recognize it with the Administrator tool GUI. My init.ora is just the default created by Oracle. Anyone have any ideas? It worked before I installed Developer? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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).
cant connect oracle after developer 9i instll
Please ignore. had to connect as SYSDBA to get it started. No idea, why the windows services couldnt start it though... this was really annoying. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan 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: Oracle position on hints -
Title: RE: Oracle position on hints - Congratulations Connor !! Raj This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: LPAR on AIX and Oracle Licensing
Oracle's Software Investment Guide talks about these things, and it's avalable from Oracle.com . Basically, if a machine can be fitted with more than four processors (even if only one or two have been placed in the box), then you have to buy the CPU option. However, if the machine architecture is such that its CPUs can be partitioned, then you can avoid this trap. I've also seen customers arguing successfully about this, even if the architecture is not hardware partiotionable. Mogens Henry, Keith wrote: Our systems folks are talking about consolidating a couple of machines by using LPARs. If we have a machine running AIX with 6 processors, can we license Oracle with 2 processors if those are segmented out within an LPAR? It's always a challenge to get hold of our sales rep, so I thought I would ask here. Keith H. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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: Oracle position on hints
Congratulations Connor! We shant tell your bride how you whiled away the hours on your wedding day. ;) Jared On Saturday 08 March 2003 17:53, Connor McDonald wrote: Just to add my meaningless diatribe to the discussion, I think that there are good hints and bad hints. For example, first_rows(n) is a good hint, in that you are giving the optimizer more information as to what your motivations are for this query, without stifling it into a choice that may not be appropriate down the track. Hints such as index(tab,idx) are bad hints, because you are more exposed to grief. If the index is renamed, then its no longer a hint. If the data distribution changes, or the index is rebuilt in reverse or compressed, then it may no longer be a good option, etc. In terms of the vendor speak of hints imply weak optimizer I think thats nonsense. Having worked with DB2 in the past, nothing used to be more irritating then coming up with bizarre convolutions on an otherwise simple SQL to ensure that certain indexes were or were not chosen. Cheers Connor PS - Its probably a little sad that I'm chit-chatting on hints on the morning of my wedding day, but hey, you gotta pass the time somehow whilst the other half is getting the hair and makeup done :-) --- Khedr, Waleed [EMAIL PROTECTED] wrote: It's like the Auto-pilot -Original Message- To: Multiple recipients of list ORACLE-L Sent: 3/8/03 2:13 PM Stephane I don't see how Oracle could ever have an official position on hints. If they say hints are going away, many developers panic. If they say hints are great, then Oracle competitors will claim Oracle has a bad optimizer. A key political issue in some shops is Using hints makes our code Oracle-specific. My reply is that hints are only comments that another database will ignore. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 07, 2003 12:19 PM To: Multiple recipients of list ORACLE-L Hi, I have to write a SQL and PL/SQL guide for our developpers. Some are good but most of them can use help. I'm not a big fan of hints except for insert append, I used them only if I really need to. In last october I went to a 3 days DB2 UDB course, unless I miss something there are no hint with DB2 UDB. So I was thinking that when the Oracle optimiser would be more mature maybe hints would go away. I just want to know what is Oracle direction with hints. TIA Stephane -Original Message- Robert - IL Sent: Friday, March 07, 2003 12:01 PM To: Multiple recipients of list ORACLE-L This is facinating, where does this come from? This is the second time in a week that I've heard this statement being made by someone. Hints will never go away IMHO, and Oracle continues to add more and more of them. I was told by someone at a client site that they were told by an Oracle instructor that they should not use hints in 9i RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 3/7/2003 10:04 AM Hi, Does Oracle have an official position on hints ? Will they go away as the optimiser is becoming bettre or they are there to stay ? TIA Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tél. (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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: Stephane Paquette 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: remote / as sysdba
Ran into an interesting problem with this on Friday. We've put together a new SAP server that is not yet attached to a network, and so are using local account names rather than the normal domain accounts until we're ready to put it on the network. ( We're replacing another server, and this one has the same name. We have to name it properly from the beginning, no switching the name to make it live.) SAP uses three types of servers in General: PRD, QAS and DEV. This one happens to be the QAS server. In this case, there are two OS accounts on the server, qasadm and sapserviceqas, that will be created with oracle accounts identified externally. Normally these appear as OPS$QASADM and OPS$SAPSERVICEQAS in the Oracle database. The name of the server is SAPQAS. After installing SAP, we hid the starter db that is installed by renaming directories, etc. We then switched in the real database that is a clone of the current QAS system. SAP wouldn't start, and wouldn't give any indication of the problem. Turning auditing on for sessions showed that the SAP services were not logging into the database. Hmmm Switched the starter database back in, and took a look at the accounts. They were somewhat different than expected: OPS$SAPQAS\QASADM and OPS$SAPQAS\SAPSERVICEQAS. The machine name had been included in the accounts names of the SAP starter database. Hadn't seen this before. Switched the cloned database backin, created accounts with machine name included ( which requires caps and double quotes due to the backslash in the account name ), assigned all privs, copied some objects and started SAP again. All worked fine after that. Is this to be expected? I still don't know nearly as much about Windoze as Unix, so maybe I need to bone up on the Windoze security. ( Don't laugh please, I have to live with it ) Jared On Thursday 06 March 2003 16:38, Jacques Kilchoer wrote: Thank you for the information. I thought the security issues were more fundamental. For example if my database has remote os authentication (with prefix OPS$), and I know that there is a user called OPS$JSTILL, then I can change the Windows Registry on my client to enable me to logon to the database as OPS$JSTILL. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] At one time you could set the 'ORACLE_USERNAME=SYSTEM' variable in your oracle.ini file, and log into any database as SYSTEM ( without a password ) as long as REMOTE_OS_AUTHEN=true. That was obviously some years ago, and I don't know if that is still possible. I would have hoped that such an obvious hole was plugged years ago. It seems to me that it was, but I don't recall details. Content-Type: text/html; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: remote / as sysdba
Jared, Look at Note 60634.1 on MetaLink. OSAUTH_PREFIX_DOMAIN = TRUE is default for 8.1 and 9. Alex. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, March 09, 2003 10:08 PM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Feinstein 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).