INDEXLEME ONEMLI

Arkadaþlar , Form içinde yaptýðýnýz ORDER BY, GROUP BY gibi fonksiyonlarý hangi tablolarýn hangi alanlarýnda yaptýðýnýzý bir yerlere lütfen yazýn. Bu alanlarda index yaratýlacaktýr. Form da blok propertilerinde order by yaparsanýz onu da yazýn . Bunyamin Your Databored Administrator

INDEXLEME ONEMLI

Arkadaþlar , Form içinde yaptýðýnýz ORDER BY, GROUP BY gibi fonksiyonlarý hangi tablolarýn hangi alanlarýnda yaptýðýnýzý bir yerlere lütfen yazýn. Bu alanlarda index yaratýlacaktýr. Form da blok propertilerinde order by yaparsanýz onu da yazýn . Bunyamin Your Databored Administrator

RE: INDEXLEME ONEMLI

Nope, I still don't understand it, even the second time around. Like the Databored Administrator bit though !!! -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: 03 September 2001 09:20To: Multiple recipients of list ORACLE-LSubject: INDEXLEME

ORA-27146: post/wait initialization failed

Hi Using Oracle 8.1.6.3 on Solaris 2.7. I get this error ORA-27146: post/wait initialization failed when trying to startup my database.. if I reboot the machine then it starts up without problems.. From reading previous e-mails.. I'm led to belive that the semaphores need to be increased.

Re: INDEXLEME ONEMLI

Yes. :- Dne po 3. zá?í 2001 10:20 jste napsal(a): Arkadaþlar , Form içinde yaptýðýnýz ORDER BY, GROUP BY gibi fonksiyonlarý hangi tablolarýn hangi alanlarýnda yaptýðýnýzý bir yerlere lütfen yazýn. Bu alanlarda index yaratýlacaktýr. Form da blok propertilerinde order by yaparsanýz

RE: Duhvelopers and DB-ehs?

OOooh, that's something I want to be able to do is to send email to us in case of problems...I can send email from OraForms using Outlook but I've not got round to checking out how I send email from a Unix box via pl/sql or the likesany suggestions? K. hit any user to continue

Shutdown and archivelog mode

Hi Using Oracle 8.1.6.3 on solaris 2.7. I am trying to put my database in archivelog mode. When I try to shutdown the database using shutdown immediate, it just sits there for ages.. (left it for 30 mins). I've cancelled this and done a shutdown abort. (tried normal shutdown after that, same)

Re: NLS_LANG

No way, only recreate the database. Jan Pruner Dne pá 31. srpen 2001 18:08 jste napsal(a): Does anyone know how or if it is possible to change the NLS_LANG value for a database that has already been created? I believe the answer is no, but I wanted a sanity check (Lord knows I need one).

Oracle for SGI Irix installation

I have a problem with intallation oracle 8.1.6 to SGI Irix 6.5.12. When i start RunInstaller and click to the Next bar of Welcome window, I can see the following errors:

Re: INDEXLEME ONEMLI

Sorry for the email . I wanted to send it to a friend but send it to list wrongly . SORRY bunyamin - Original Message - From: Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L Sent: Monday, September 03, 2001 12:20 PM Subject: RE: INDEXLEME

RE: OT: RE: Duhvelopers and DB-ehs?

well if you didn't keep paying me in bloomin' bananas me and me mates would never have gone on strike!! ;-) LOL hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366

Re: OT Re: INDEXLEME ONEMLI

Well... I guess Bunyamin was trying to warn their developers about indexing and he has sent it wrong. Gints, it is Turkish not Turkic. Anyway, we are at the quarter finals, hoping to get the cup.. Okan Never argue with an idiot, they will drag you down to their level and beat you with

OT Re: INDEXLEME ONEMLI

Although there is European Basketball Championship in Turkey and I'm a big fan of it, I don't know Turkic (I suppose so) now ;))) Gints Plivna IT Sist?mas, Mer?e?a 13, LV1050 R?ga http://www.itsystems.lv/gints/

UNIX LINKS QUESTION ??

My unix knowledge is low and I want to develop it . But I search for a tutorial for Oracle People especially DBA's. IS there a source on web including the directory structure, oratab or other things to administer a database on Unix system ? I' ll be so happy for your helps . Thank you

a little sql question

hi every body, I need to insert in the end of a sql script, the number of rows returned. how can i do that ? thanks !!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

RE: Duhvelopers and DB-ehs?

Hi Don, and well done for taking the step back towards a normal life...(whatever the heck that is!)... LOL hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141

How to remove the old service of Oracle from win2k

Hi, Experts: After I tried with difference listener name in Win2K, it generated some services. Something like: OracleTNSListener80, OracleTNSListener80list804, OracleTNSListener80List805 and so on. They were generated automatically each time I start the listener with a new listener name.

Re: Duhvelopers and DB-ehs?

- PACKAGE utl_smtp AS /*** * OVERVIEW * * This package provides SMTP client-side access functionality in PL/SQL.

Smallest possible instance.

Hello all, Does anybody know the smallest possible size (SGA etc.) that an instance can be, and still run and accept connections? We have a test laptop that will be running Oracle 8.1.7, along with some of our tools against it, so the instances only need to accept around 2-3 connections.. If

RE: Duhvelopers and DB-ehs?

Use UTL_SMTP http://technet.oracle.com/doc/oracle8i_816/server.816/a76936/utl_smtp.ht m g -Original Message- Sent: Monday, September 03, 2001 10:41 AM To: Multiple recipients of list ORACLE-L OOooh, that's something I want to be able to do is to send email to us in case of

Re: Duhvelopers and DB-ehs?

Hi, take a look at the UTL_SMTP package. | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FBOM | | Tel.: 0211/533-4893| Thomas, Kevin schrieb: OOooh,

RE: Duhvelopers and DB-ehs?

Thanks Jan, I'll check and see if we have access to this package... hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -Original

Re: OT Re: INDEXLEME ONEMLI

Yes Okan , thank you. bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 03, 2001 1:20 PM Well... I guess Bunyamin was trying to warn their developers about indexing and he has sent it wrong. Gints, it is Turkish not Turkic.

OEM on HPUX

Guys, has anyone set up Enterprise Manager 9.0.1 on HPUX? More specifically the Intelligent (now there's a misnomer!!) Agent? When I try to autodiscover nodes, it says the Agent is not running. I then run agentctl status and get the message Required configuration file snmp_ro.ora not

Re: Duhvelopers and DB-ehs?

... or the likesany suggestions? will be much more easier to hire some office-girl and let she mail it manualy than drive some developer to write the code :-))) JP Dne po 3. zá?í 2001 13:10 jste napsal(a): Thanks Jan, I'll check and see if we have access to this package... hit any

RE: a little sql question

set feedback on Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : Djaroud Salim [mailto:[EMAIL PROTECTED]] Envoyé : lundi 3 septembre 2001 10:30 À : Multiple recipients of list ORACLE-L Objet : a little sql question hi every body, I need to insert in the end of a

Re: Shutdown and archivelog mode

do a shutdown normal ALWAYS after issuing a shutdown abort. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 03, 2001 3:16 PM Hi Using Oracle 8.1.6.3 on solaris 2.7. I am trying to put my database in archivelog mode. When I

RE: How to remove the old service of Oracle from win2k

in the RESKIT, you have a tool called SRVINSTW.exe that allows you to add/remove services. /Maya -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of WinterSun Zhao Sent: Monday, September 03, 2001 12:45 PM To: Multiple recipients of list ORACLE-L

Re: Shutdown and archivelog mode

Sajid, The db must be cleanly shutdown (normal or immediate) in order to change the archivelog mode. A shutdown immediate may not shutdown immediately for several reasons, most commonly: 1. There is an uncommitted transaction that needs to roll back. 2. SMON is deallocating temp segments

Re: ergent help: ora-27091 on system tablespace

Corruption in the system datafile takes special handling so if you haven't already done so I highly recommend logging a tar with support. If you are unable to even cp or dd the file then you most likely have a problem with the file at the OS level and you need to get that issue resolved. As to

IMP-00069 error when importing 8.1.7 export

Hi list, I have a problem when importing a 8.1.7 export to my 8.1.7.0.1 Oracle on Linux. Export was done with characterset UTF8, I tried to import with characterset WE8ISO8859P1, WE8ISO8859P1 and UTF8; nothing works. Any help is welcome. TIA Volker Schön E-Mail: mailto:[EMAIL PROTECTED]

Re: Analyze all indexed columns

Iain, This is covered in greater detail in the SQL Reference manual under the Analyze command, but here's a summary of the basics. Computing/estimating statistics on the table (without a FOR clause) calculates/estimates stats for the table and its indexes. The for clause has the following

Re: How to remove the old service of Oracle from win2k

A sneaky little trick on 8.0.6 and below is to use oradim to remove the service. ORADIMxx -DELETE -SRVC service_name where ORADIMxx is oradim73 or oradim80 service_name is the name of the service to be deleted (it is not case sensitive) Be very careful as you can use this to delete

Re: NLS_LANG

Jan and Todd, In Oracle8 and above this can be done provided you want to convert the db to a strict superset of the existing character set (e.g. US7ASCII to WE8ISO8859P1). Otherwise the only supported option is to recreate the db via export/import. See the following metalink docs: Note:

OL$ and OL$HINTS Tablespace

Listers, I don't have access to Metalink so I can't check this out. Does Oracle support moving the OL$ and OL$HINTS tables to a different tablespace, or, do they frown upon this? I know they used to have note talking about moving the AUD$ table and index to a different tablespace, but, it seems

migrating from 8.0.5 to 8.1.7

hi migrator, any one have problems with packages or stored procedures ?? wait a feedback ! thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

RE: UNIX LINKS QUESTION ??

I have not used this, but Don Burleson has a book : Unix for Oracle DBAs Pocket Reference http://www.oreilly.com/catalog/unixoracledbapr/ HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Bunyamin K. Karadeniz

RE: ORA-27146: post/wait initialization failed

Hi, You can find the info you're looking for in the install guide , chapter 2 Pre-installation Configuring the Kernel for Oracle8i. I had to increase the semaphores when I tried to create a 2nd instance on my server, it was working fine at first db creation. I used the default values

Re: NLS_LANG

Nice, but it never works for me. I have tried to convert from ee8mswin1250 to utf8 and it didn't convert right the czech signs. JP Dne po 3. zá?í 2001 15:50 jste napsal(a): Jan and Todd, In Oracle8 and above this can be done provided you want to convert the db to a strict superset of the

Re: INDEXLEME ONEMLI

Thank you Rahul , It worked perfect . :)) Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 03, 2001 4:25 PM instead of ORDER BY use YADAYADA BU , it will work :-) -- From: Jan Pruner[SMTP:[EMAIL PROTECTED]]

Re: IMP-00069 error when importing 8.1.7 export

Hi, can you export your 81700 db with the 81701 exp utility? oli [EMAIL PROTECTED] wrote: Hi list, I have a problem when importing a 8.1.7 export to my 8.1.7.0.1 Oracle on Linux. Export was done with characterset UTF8, I tried to import with characterset WE8ISO8859P1, WE8ISO8859P1 and

RE: !! Keeping the list alive

Man, I remember the day when there were about 60 IT staff here. Now, I believe its under 20 or will be very shortly. It was a tough week here last week. We had to match what our client was letting go so we did that no problem. Pretty much everyone is off to another project from us. But to

RE: OT RE: database consistency tools ?

Um, headphones? I would die to be able to play music at work. For some reasons safety won't let us. They claim its because then we can't hear the overheads. Damn, I can't remember the last time I was able to make one out anyway -Original Message- Sent: Friday, August 31, 2001

RE: Duhvelopers and DB-ehs?

well, we don't send it out of pl/sql directly, we run shell scripts that run the sql, then use shell to check the results and if it meets the send a message criteria, we use mail or mailx to send it. you can use pipes to call unix shell programs though From: Thomas, Kevin [EMAIL PROTECTED]

Re: tablespace corrupted and no backup , how to remove it ?

Why would you be annoyed that the database doesn't open with a corrupted tablespace? That's what';s SUPPOSED to happen. okay, we just did this a few days ago but here it is again: startup mount alter database datafile 'filename' offline drop; (repeat this for every datafile in the tablespace)

Standby database

Hi All, I'm resaerching standby database on 8.0.5 here and have a question. Setting up the standby database is quite well documented, but how to configure the clients in such a way that they will first try the primary site and if that's not responding try the standby site. Oracle

Re: OL$ and OL$HINTS Tablespace

yes they do support it. hth connor --- Larry Elkins [EMAIL PROTECTED] wrote: Listers, I don't have access to Metalink so I can't check this out. Does Oracle support moving the OL$ and OL$HINTS tables to a different tablespace, or, do they frown upon this? I know they used to have note

RE: !! Keeping the list alive

Time to chip in my horror story (and why I'll never do permie again). Company in OZ decided to cut down numbers. Bosses walked around with security guards into each persons office and tell them they have 5 minutes to leave to premises and give them a ticket which has a 15minute after-hours

RE: Duhvelopers and DB-ehs?

Yea, I've got the 'running the unix shell script' part down...did you see the mails someone sent re: utl_smtp?? hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366

SEMAPHORES AND ORACLE

Hi listers, AIX 4.3.3.0, Oracle 8.1.7 I have been recieving ORA-01041on some clients with Hostdef extension doesn't exist I searched Metalink looking for some answers and all the info points to semaphores configuration vrs oracle processes. Oracle processes is set to 500, but I don't know

RE: !! Keeping the list alive

That is disgraceful. Here when people were let go they were at least treated properly, given good packages (over and above what was legally required), and the services of a careers counciller to help them prepare their cv, brush up on interview techniques contact reqruitement agencies etc.

Re: SEMAPHORES AND ORACLE

Veronica, Oracle on AIX doesn't use semaphores, as AIX has it's own post-wait driver and Oracle doesn't need it's own, hence no semaphores. Details: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=15566.1 Any other errors, stuff in the alert.log,

PL/SQL HEXTONUMBER

Dear lists ! Does anyone have a PL/SQL procedure converting a hexadecimal value to a decimal one , please ? Thanks a lot in advance ! DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin

Re: PL/SQL HEXTONUMBER

http://www.jlcomp.demon.co.uk/faq/base_convert.html --- Andrey Bronfin [EMAIL PROTECTED] wrote: Dear lists ! Does anyone have a PL/SQL procedure converting a hexadecimal value to a decimal one , please ? Thanks a lot in advance ! DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL

Calling C++ component from PL/SQL

Hi all, I have requirement of calling C++ component from PL/SQL. What should I do for this? For calling Java Class we have to first run initjvm.sql to load dbms_java packagae and then publish Java class. Then after we can call java class as function in PL/SQL. Similarly what are

Re: How to remove the old service of Oracle from win2k

WinterSun Zhao wrote: Hi, Experts: After I tried with difference listener name in Win2K, it generated some services. Something like: OracleTNSListener80, OracleTNSListener80list804, OracleTNSListener80List805 and so on. They were generated automatically each time I start the

Re: Smallest possible instance.

Mark Leith wrote: Hello all, Does anybody know the smallest possible size (SGA etc.) that an instance can be, and still run and accept connections? We have a test laptop that will be running Oracle 8.1.7, along with some of our tools against it, so the instances only need to accept

Re: Datawarehouse suggestions?

ÌÌÌ X-Declude-Sender: [EMAIL PROTECTED]

RE: !! Keeping the list alive

I went through several major cuts when I worked at Citibank. The first one was the one best handled... by the time anyone was told about it, it was if you are here listening to me, you are NOT one of the ones let go Worst was when we knew how many would be let go... and knew that they had let

Re: Standby database

On Mon, Sep 03, 2001 at 08:45:24AM -0800, [EMAIL PROTECTED] wrote: Hi All, I'm resaerching standby database on 8.0.5 here and have a question. Setting up the standby database is quite well documented, but how to configure the clients in such a way that they will first try the primary

RE: Duhvelopers and DB-ehs?

yup I did... and I also have a friend who has had tons of trouble setting up mail via utl_smtp it's definitely a way to go though. it won't monitor things like disk space in the OS and you have to configure it and then set up the job in EACH db, instead of running through a list of databases

RE: OT RE: database consistency tools ?

well, the only announcements we ever hear are the monthly test of the fire alarms that seem to go off twice a week. From: Kimberly Smith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT RE: database consistency tools ?

Re: Standby database

Well, you can configure the tnsnames.ora to check multiple listeners, so you do that... the first listener/port you check is the primary, the second is the standby From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Standby

Re: ora-600/ora07445

ÌÌÌ X-Declude-Sender: [EMAIL PROTECTED]

gzip'ing rman backups

Hi folks, I want to gzip up my rman backups, which are to disk. I do a full at the weekend, and archive logs daily. I know that rman cant cope with zipped files, and I will have to unzip them myself before attempting a restore. My question is - does rman ever check existing backup files - will it

Re: Re: How to remove the old service of Oracle from win2k

Hi, Bardeen: Thank you for your help. Because I had set my default Oracle_home pointed to the home of oracle8.1.7, so I removed the services of Oracle8 failed. With your help, I set the oracle_home to the home of Oracle8 and then I used oradim80 and I can remove the services I didnot

Re: Re: How to remove the old service of Oracle from win2k

Hi, Bardeen: Thank you for your help. Because I had set my default Oracle_home pointed to the home of oracle8.1.7, so I removed the services of Oracle8 failed. With your help, I set the oracle_home to the home of Oracle8 and then I used oradim80 and I can remove the services I didnot

Re: Re: How to remove the old service of Oracle from win2k

Hi, Paul: Thank you for your help. The problem had been solved with the help of A. Bardeen ([EMAIL PROTECTED]). Thank you. WinterSun Zhao wrote: Hi, Experts: After I tried with difference listener name in Win2K, it generated some services. Something like:

Re: SEMAPHORES AND ORACLE

If you're on 8.1.7.0.0 it may be a bug. Apply the latest patch. [EMAIL PROTECTED] 09/03/01 16:10 PM Veronica, Oracle on AIX doesn't use semaphores, as AIX has it's own post-wait driver and Oracle doesn't need it's own, hence no semaphores. Details:

Re: gzip'ing rman backups

hi mark, does rman ever check existing backup files - will it look for the last full backup before backing up todays archive logs etc RMAN simply backs up whatever u ask it to back up (db/tblspace, etc) .. it does not do any sanity checks.. note that it records all entries for succesfull

Re: ergent help: ora-27091 on system tablespace

hi, bardeen: Thanks for your reply. The database has a valid backup, and after the backup, no further operation is done.So, what i shall do is only to restore that full backup and it is OK. Now i wantto know why this happen, and if the disk is error itself.For Oracle doesnot know it:

RE: !! Keeping the list alive

someties i think life sucks .. screw oracle and 9i .. give me some nice vacation time here .. i need a break ;) .. like most of ya'll in the list enjoy deepak --- Steven Hovington [EMAIL PROTECTED] wrote: That is disgraceful. Here when people were let go they were at least treated properly,