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

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: 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

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

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: 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

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: 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

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: 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

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: 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

Re: Failed login attempts

I tried What you said . but still no rows returns from dba_audit_trail although failed login attempts occured. 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

THANKS Re: problem in creating control file?

log mode parameters in the new init.ora file and created the control file withthese options: SET , RESETLOGS and NOARCHIVEMODE Then every thing was ok . And then changed the new db to archive llog mode. Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir

Autoextensible of RBS and Temp datafiles.

Dear Gurus, I am always making RBS and TEMP tablespaces set as Autoextensible=false. Is it true ? or logical? Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729

problem in creating control file?

FILE failedORA-01161: database name TESTDB in file header does not match given name of TEST2ORA-01110: data file 1: 'D:\yedek123\SYSTEM01.DBF' TESTDB is the original database . TEST2 is new DB. What is the problem ? Thank you. Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHav

Another problem in cloning database

to be consistentORA-01110: data file 1: 'D:\YEDEK123\SYSTEM01.DBF'SVRMGR 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

Re: problem in creating control file?

"TEST2" RESETLOGS ARCHIVELOG HTH John -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: 12 March 2002 11:48To: Multiple recipients of list ORACLE-LSubject: problem in creating control file? I try to clone my da

Re: Autoextensible of RBS and Temp datafiles.

thank you ... 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

Re: Locally managed ts

This package(DBMS_SPACE_ADMIN ) does not allow changing dict. managed TS to Locally managed ts. It allows reverse. 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

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

Re: replication question

: Bunyamin K. Karadeniz To: Multiple recipients of list ORACLE-L Sent: Monday, March 04, 2002 3:33 AM Subject: replication question Dear Gurus, The clients will enter records to a database all day and I will update the other database . I need

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 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: 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

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: 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: 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: 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

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: 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

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: 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: 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: 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

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?

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

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

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

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

Career Question ?

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

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

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

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

Re: DBA CHECKLIST

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 Diego, California

bad BIND variable

IWANT TO CREATE a dynamic trigger where inside; :new.column_name occurs and column_name changes in a loop . DECLARE cursor c1 is select column_name from arsiv.logged_columns where table_name = 'K_IMID_KURUM' ;kolon c1%rowtype; BEGINFOR kolon IN c1 LOOPye := :new.||kolon.column_name;

Re: Oracle related docs/OCP materials

For me too.. - Original Message - From: Stephen Andert To: Multiple recipients of list ORACLE-L Sent: Monday, November 12, 2001 10:15 PM Subject: Re: Oracle related docs/OCP materials Boy, this was sure a disappointment. No white papers that I could

ora-03116

we are experiencing ora-03116 error (invalid buffer length) How can we solve this . ? Urgent please . Thank you . Any Ýdea please ? bunyamin

procedure in a package and joining it to a FORMS block.

I can set a procedure to a block in Forms 6i . But can not do it to a procedure in a package . IS IT POSSIBLE? Thanks . bunyamin

LINUX ORACLE INSTALL ERROR

I have succesfully installed oracle 8.0.5 on LINUX redhat 7.1 BUT when I want to run sqlplus or lsnrctl it gives SEGMENTATION FAULT error. and creates core dump files. Why does this occur? Has anyone experienced this before ?

Nostradamus told .

in the city of god there will be a great thunder, two brothers torn apart by chaos, while the fortress endures, the great leader will succumb" , "the third big war will begin when the big city is burning" nostradamus 1654 Sent by one of my friend . I hope this will not be true. For this

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: 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

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

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

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

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 =

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

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

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

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

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: 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

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: 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

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

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: 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

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: get yesterdays date

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

  1   2   >