Re: What columns are in the Primary Key

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Max two dates

I have a date field and I want to select rows with max 2 date values. How can I do that? Thank you.

Re: Max two dates

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

IMP 8.1.6 to 8.1.7 DB

I have an export(full) of 8.1.6 and I wonder if it is ok to import it to 8.1.7 ? Thakn you

Re: IMP 8.1.6 to 8.1.7 DB

. Saurabh Sharma [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 08, 2001 1:25 PM Subject: IMP 8.1.6 to 8.1.7 DB

closing DB on NT with a scheduled BATCH FILE

Dear Gurus , I have a question , In fact I wonder if it is a bug of NT . I want to close and reopen database with a .BAT file . When I executethe .bat file directly it executes correctly . But When I execute it with a schedule with AT command then it connects but does not close database.

Re: PL/SQL length overflow prob

ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: closing DB on NT with a scheduled BATCH FILE

sure your batch file runs? Do you create logs? If so, did you check if log was created? How do you know it connects. I have similar batch files. They run either way with no problems. -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent

Re: closing DB on NT with a scheduled BATCH FILE

this in the AT scheduler, it is not executing with the same permissions. I'll bet that your batch script it not on the C: drive. Put it on the C: drive and see if it works. Jared Bunyamin K. Karadeniz To: Multiple

ON UPDATE CASCADE?

I want to update referencing tables when the master table is updated. Does it have an easy wayas in on delete cascade or do I need to Write code? Bunyamin

no email comes from list ?

no email comes from list to me? Why can it be? Bunyamin

Re: Help scheduling Hot Backup on NT...

FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE you

blob field and FORMS6i

I want to insert into a table and open a pdf and word document. here is the table create script . And I do a FORM and assign the blob field as OLE Conteiner and the problems start. And I can not do that . How do you do that ? Any idea please?Anyone did something like this Thank you

Re: How do they get the answer?

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

URGENT PLEASE ! tns service deletion and recreation

OS: NT 4.0 I need to delete the TNS Listener service . and create a new one . How can I do that ? TIA Bunyamin

tns service error

I am getting the below error where I run STAT or STOP command of LSNRCTL on 8.1.7 on NT. Content of listener.ora is also below. Why is that ? Note : I can remotely connect to this database from client. Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))TNS-12541: TNS:no listenerTNS-12560:

OK I HAVE DONE IT.........Re: URGENT PLEASE ! tns service deletion and recreation

create your listener services. "Bunyamin K. Karadeniz" wrote: OS: NT 4.0 I need to delete the TNS Listener service . and create a new one .How can I do that ? TIABunyamin

creating the database from another

I have a 8.1.6 database on NT on one machine . And I want to create this database to another machine where oracle is installed but there is no database. I have the back up of datafiles,control files and redo log files and archieve files. Can you tell What I will do step by step ? Is there

RE: creating the database from another

Ok Thomas , thank you but another question rises here for me. The drive of soucedb is E but my targetdb will be on D drive. How will I manager that ? And in the control file backup , there is "reuse" keyword . will I neglect it? Thank you Bunyamin

Re: creating the database from another

od Luck! Tom Mercadante Oracle Certified Professional -Original Message-----From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 28, 2001 3:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: creating the database from another Ok

Re: tab ascii value

Title: RE: tab ascii value This script prints the ascii table whole. May be usefull. Bunyamin set serveroutput on size 10240 declare i number; j number; k number; begin for i in 2..15 loop for j in 1..16 loop k:=i*16+j; dbms_output.put((to_char(k,'000'))||':'||chr(k)||' '); if k mod 8 =

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

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

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

Re: OT Re: INDEXLEME ONEMLI

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: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City

Re: INDEXLEME ONEMLI

-- Author: Bunyamin K. Karadeniz 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

oracle 805 on linux mandarake 7 install error.

I try to install oracle 805 on linux mandarake 7 but . When installing the selected products it gives the error below. error : command : make -f ins_rdbms.mk /u01/./rdbms/lib/psoliblist sh : command not found why can it be ? Thank you

Re: What's up with http://www.unal-bilisim.com/

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: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City

Re: query for top customer

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

SO UPSET FOR ALL AMERICANS

I HOPE BEST WISHES FOR ALL PEOPLE IN AMERICA . WE TURKISH PEOPLE ARE ALL SORRY AND HOPE YOU HEALTH. BUNYAMIN

Re: sysdba

I had taken the same error sometime ago and droped and recreated password file .that is a solution 1 . Try logging as internal and change the password of sys . then try again . Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey

ORA-00600 error

Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. dbainblk.gif Description: GIF image

Re: ORA-00600 error

Title: Message Yes I am running 8.1.7.3 .. Is this a bug ? What will I do then? Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database

WHICH UNIX FOR ORACLE?

We are searching about which unix is best ? We will apply 9ias and 8.1.7 DB . plus Oracle Portal. Can you direct me to a link for comparison about SOLARIS , AIX , HP-UX for performance and other options .. Thank you ... Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian

very interesting problem with V$SESSION and web applications....

mind Any idea please ... Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.

Re: very interesting problem with V$SESSION and web applications.

T('USERENV','CLIENT_INFO')REAL_USER_NAME Hope this helps Paul-Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Friday, April 05, 2002 4:16 PMTo: Multiple recipients of list

Re: MetaLink problems

I have tried and entered to metalink too. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its

SHARED_POOL_RESERVED_SIZE pool question

Dear Gurus, SHARED_POOL_RESERVED_SIZE is for big database objects (procedure,function,package) as far as I know. I want to configure my database for pinning codes greater than 500K to reserved pool , smallers to shared pool . How Can I do that ? Thank you Bunyamin K. Karadeniz Oracle

Re: Script for identifying objects having freelists contention

SELECT s.segment_name,s.segment_type,s.freelists,w.wait_time,w.seconds_in_wait,w.state FROM dba_segments s , V$session_wait w WHERE s.header_file=w.p1 AND s.header_block=w.p2; Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km

Re: MySQL vs. Oracle database

stored procs ,functions are unavailable .. Wonder if it has now.. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely

DBMS_SHARED_POOL.KEEP

, It did not work too. How can I do this? Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA.

Re: DBMS_SHARED_POOL.KEEP

Tried and does not work .. Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA

STANDBY DATABASE QUESTION?

, PAGEFILE.SYS file is nearly 2 GB , AND does not increase , Why is it so big ? I know that it is because of SWAP .But I am sure that there must not be swap since I have 8 GB ram and only 40 users use database for now. . . Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan

Re: STANDBY DATABASE QUESTION?

thank you all... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. - Original

Re: executing a stored procedure at a certain time

Title: executing a stored procedure at a certain time I do it in this way .. Firstly , dbms_job.submit giving the interval .. then dbms_job.next_date... Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312

Re: Memory?

I have an idea .. PGA = UGA(user_session_data + cursor state)+stack space So Will it be enough or do I have to add sort_area_size to the value below? select * FROM v$SESSTAT a ,v$STATNAME b WHERE a.statistic#=b.statistic# and name like 'session pga memory' ; Bunyamin K. Karadeniz

Tuning Question and Advice needed ..

mes "direct path write" occured for 6000 times Are these values normal ? Will I try to make them 0 in the tomarrows report ? How can I comment on the report ? Is there a link you can tell me to understand the problems and will help me to read and action about the problems ? Thank

Re: Tuning Question and Advice needed ..

Thank you Sergey .. Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday

Re: CPU Pegged at 100%

I have 5 DBWR processes according to INIT.ORA on NT .. I see them on V$SESSION but There is only one process ORACLE.EXE in the processes list of NT still. I do not understand the behaviour of ORacle on NT neither the Oracle I think. Bunyamin K. Karadeniz Oracle DBA / Developer

Certification of Brainbuzz and BrainBench

Dear Gurus , I want to take a certification and I wonder if brainbench and brainbuzz certifications will help me in my job search. Are these really as valuable as to write to the CV. Do you recommend them ? Why I prefer these examsis cheaper price .. Bunyamin K. Karadeniz

Re: Certification of Brainbuzz and BrainBench

Thank you Dennis... Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Mobile : +90 535 3357729 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday

Re: SQL help

: 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: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network

ORA-12545 WHEN CREATING A NEW DATABASE

Dear Gurus , I have a problem. I have 2 databases on an win2000 machine and want to create the third . When I try to create a database with Database Conf. Assistant , it creates the service and before creating datafiles it gives error ORA-12545 and does not create datafiles although I ignore

Runing OS Commands from Stored Proc.

I want to write a procedure to run os commands . I have read somewhere that I must :Compile the java program. Load it to the DB using LOADJAVA. Create a function call spec to call the program. Turn serveroutput and java output ON. Question 1) What is loadjava? how is it used ? 2) How is

Re: Runing OS Commands from Stored Proc.

NOTE: 109095.1 Bunyamin K. Karadeniz wrote: I want to write a procedure to run os commands . I have read somewhere that I must : Compile the java program. Load it to the DB using LOADJAVA. Create a function call spec to call the program. Turn serveroutput and java output

Career Question ?

Doesanybody know any websites of Germanyor England related with Oracle jobs ?

Re: database administration questions

1) %50 DBA , %50 Developer 2) Yes 5) all , Java and xml are more. 6) XML, VB 7) Yes , but I did not too. 8) Yes,OCP 9) Learning oracle will be enough to fill your all time. 10) This email list 11) I am interested in the answer of this question too. 12) I am interested in the answer of this

ROLE COUNT

Hi DBA's The number of max roles is 150 according to init.ora . Is it possible to increase it ? Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1681

Re: ROLE COUNT

Ok . You are right . Thank you. bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 07, 2002 12:15 PM Bunyamin K. Karadeniz wrote: Hi DBA's The number of max roles is 150 according to init.ora . Is it possible

trace file question

I have a trace file generated by the database. At the end of the file you will see an error of Session 10 exceeded soft sessionspace limit of 0x10 bytes. What is this ? How can I handle that if needed ? Thank you bunyamin Dump file G:\orafiles\uybs3\tracefiles\udump\ORA01216.TRC Fri

URGENT , ORA-00600 WHEN DROPING A PACKAGE

What can I do ? Urgent please SQL drop package wwsso_home;drop package wwsso_home*ERROR at line 1:ORA-00600: internal error code, arguments: [16201], [], [], [], [], [], [], [] SQL drop package body wwsso_home;drop package body wwsso_home*ERROR at line 1:ORA-00600: internal error

Re: URGENT , ORA-00600 WHEN DROPING A PACKAGE

Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: 08 January 2002 09:55To: Multiple recipients of list ORACLE-LSubject: URGENT , ORA-00600 WHEN DROPING A PACKAGE What can I do ? Urgent please SQL drop package wwsso_home;drop package

CHAINED ROWS

I have seen that There are some number of chained rows in several tables of a schema in my database . What is it done in such a situation ? Thank you Bunyamin

HAS anyone tried advanced security and tcp_ip with SSL?

HAS anyone tried advanced security and tcp_ip with SSL? We will make a project which will be on web. So we are searching for security implementations. What will we design for to stop hackers? Database Now 8.1.7 but may be 9i if needed. OS : WIN2K Advanced Server. Can you direct me to

RUNNING .BAT FILE FROM PROCEDURE ?

OS : WINNT , DB : 8.1.7 I have a java class embedded in database and I am calling it with a procedure. The procedere executes a bat file . In the bat file there 2 copy commands . First of them copying a file from a local directory to another local directory. Second command copy's a file

Re: RUNNING .BAT FILE FROM PROCEDURE ?

used to run Oracle service. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Thursday, January 10, 2002 7:40 AM Subject: RUNNING .BAT FILE FROM PROCEDURE

Server mode

My first question is , Ineed a database where 1000 clients will work .Which is better ? Dedicated Server Mode or Shared Server Mode ? RAM : 8 GB CPU : 8 * 1000 MHZ WIN 2K My second question is , I can not select more then 600 mb of RAM to be the buffer cache . How can I solve this?

Re: Server mode

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: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: Backup Strategy

') 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: Bunyamin K. Karadeniz INET

Re: Using Java Blocks Can Anyone Help?

Jay , You need a java class loaded into database Which runs OS Commands (or .bat file) . For this look at below... ... Hope this helps . (But I could not manage to run OS commands deleting files from network altough shared.But locally it works fine.) Bunyamin K. Karadeniz Oracle DBA

Re: DATABASE COMPARE SCRIPT

Title: RE: When to go for ORACLE NAMES Server -- DATATYPE.sql -- -- To check datatype consistency between two environments -- -- SELECT table_name, column_name, data_type, data_length, data_precision, data_scale, nullable FROM

dbms_alert and dbms_mail utilities

Hi, Gurus, My client wants me to alert him from the application or send an email of spesific rows of a table daily. I have email programs but I want to do it with oracle packages. But I could not find documentation on dbms_alert and dbms_mail utilities .How will I do it ? Can you help

file output of a SP

Hi Gurus, I have a problem, I am trying to output a txt file of my query results. But all these will be in a stored procedure, Andinthe procedure , how will I open a file and write to it and then close it ? Thanks

Re: file output of a SP

file to use the package which means you'll need to bounce the DB. Regards David A. Barbour Bunyamin K. Karadeniz wrote: Hi Gurus, I have a problem, I am trying to output a txt file of my query results. But all these will be in a stored procedure, And in the procedure , how

job offer from SAUDI ARABIA

Hi all , I have taken an offer from a company in Europe to work in Saudi Arabia for 2 years. But I must learn the living conditions there. Ýf there is an Arabian here , can you answer these.. 1) How are the living conditions?Expensive? 2) Will my wife have to cover her hair? Is it

Re: job offer from SAUDI ARABIA

-- Author: Bunyamin K. Karadeniz 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

Re: job offer from SAUDI ARABIA

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: ??? strange database link problem

Title: RE: ??? strange database link problem # Global Naming -- enforce that a dblink has same name as the db it connects toglobal_names = true Your problem is this. make it to false or obey the rules. - Original Message - From: Libal, Ivo To: Multiple recipients of list

PCTFREE/PCTUSED

PCT_USED = PCT_FREE + 1 row sizePCT_USED + PCT_FREE 100 Are the rules . But what does 1 row size mean here? For ex . My pctfree=30 1 row size (avg.) = 150 bytes . Then what is PCT_USED ? TIA

!!!! sorry for viruses !!!!

I did not understand why but my computer started to send messages to people which are virused. Sorry from everyone. Bunyamin

dbsnmp package

Hi all gurus, My question is how can I query the database for which packages are installed? I wonder if dbsnmp is installed? Thank you. Bunyamin

urgent !!

Hi all gurus.. I want to create my database on NT . but svrmgrl gives error of SVRMGR startup nomount pfile=D:\oracle\ora816\admin\uybs\inituybs.oraLRM-00109: could not open parameter file 'D:\oracle\ora816\admin\uybs\inituybs.ora'ORA-01078: failure in processing system parameters How

Re: urgent !!

would suggest that your init.ora file is not where it should be ie. check that D:\oracle\ora816\admin\uybs\inituybs.ora is exactly where the parameter file is and that it is named correctly. Cheers Lee -Original Message-From: Bunyamin K. Karadeniz

procedure error

Dear Gurus. Icreated a procedure and this procedure takes parameters and then makes and alter table DDL on the database. Butwhen I write exec pp(table_name1,field,table_name2); Gives error. ERROR at line 1:ORA-06550: line 1, column 10:PLS-00357: Table,View Or Sequence reference

smart array 12000

Is there anybody who knows about Smart Array 12000 disks. I need to install datafiles on these disks . Is it a RAID5 system?

STARTUP ??

os :WINDOWS ADVANCED SERVER 2000 DB: ORACLE 8.1.6 MY question is how to execute a script on each startup of database on NT ?? Thanks Bunyamin

Very Large Databases with 50.000 or more clients....

that ? Do you have links for me to read for a typical big application ? Thank you so much Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217

Re: stopiing write to listener.log

Shibu , IF you type LSNRCTL HELP YOU WILL SEE THE SET OPTION THEN TYPE HELP SET you will see the log_status action .. type show log_status . and be sure that it is ON. Then try to make it OFF with the SET command ... Bunyamin - Original Message - From: [EMAIL

DO YOU HAVE ANY DATABASE RUNNING ACTIVE 1000 SESSIONS ?

My question is DO YOU HAVE ANY DATABASE RUNNING ACTIVE 1000 SESSIONS ON NT ? I WILL TRY Multi Threaded Server BUT STILL I HAVE DOUBTS ? DO YOU HAVE LINKS TO ADVICE ME TO READ ABOUT THIS POINT ? ( HIGH CONNECTION/TRANSACTION NUMBER PER SECOND) THANK YOU

Re: BIG DATABASE second post

balancing or Do I need it for 1000 active users? Thank you So much ? Any idea will be very good for me? Bunyamin K. Karadeniz Oracle DBA / Developer Civilian IT Department Havelsan A.S. Eskisehir yolu 7.km Ankara Turkey Phone: +90 312 2873565 / 1217 Get Your Private

Re: Frequency of Analyze

Title: Frequency of Analyze It is due to your data change. Ifsmall number of of data change occurs you may need to do itmonthly . But I have read somewhere that Analyze is recommended for every week for oltp databases. Bunyamin - Original Message - From: Arslan Dar

Re: Oracle Licensing - Concurrent users

FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Lost a redo disk

, 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: Bunyamin K. Karadeniz INET: [EMAIL

Re: moving from unix to NT

see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Anybody immigrated to Australia.

to take advice from these people if there are. Thank you .. Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217

replication gui

I have oracle ent. edition on my machine (NT) but do not havethe link of adv. replication manager in start panel . What is the name of exe starting the Replication manager ? thank you bunyamin

Re: Reset sequence curret # to the beginning

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: Bunyamin K. Karadeniz INET: [EMAIL PROTECTED] Fat

replication question

Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need to replicate 10 tables in a database to other database at a specific time. Do I need Advanced replication or basic replication . ? How can I understand that replication is

how are the snapshots refreshed ?

Dear Gurus, I have made 10 tables as snapshots . And I want to refresh them for specific intervals. How can I do that ; I have tried DBMS_SNAPSHOT.REFRESH_ALL_MVIEWS but could not succeed . How is it done ? Bunyamin

  1   2   >