Recent content by amolso

Is there any difference in tns and listener conf for oracle 8i on windows 2000 and NT server. I have installed oracle 8i on NT where it is working fine and just now I have installed Oracle 8i (same version) on win2000 on a machine and I have given the same name to global database name which I...

Hi Ken Thanks . I got the answer for my problem. What you have said is true but there is no need for 3 functions. This can be done using ref cursor. Please go thru http://govt.oracle.com/~tkyte/ResultSets/index.html Amol New to dba world, so please ......

Hi I have got a problem. I have java program which calls a oracle stored procedure and it works fine if output is single row. We can use cursor in procedures to display output on SQL> but this does not work for Java program. In Java program I am using PrepareCall() to execute the stored...

How can I write a trigger or function which will notify a java object about a particular event on a database table. First of all is it possible to refer any java object through SQL Amol New to dba world, so please ......

Hi all This is a query related to change in the password of internal. I am working on Oracle 8i (8.1.6) on Windows NT. I want to set up password for internal user for my own machine to prevent users from using Oracle DB Access as admin. For this I have used exact procedure told Oracle in...

Hello Everybody I am working as Oracle DBA in an organisation which specialises in E-biz and Network Management Solutions. Now as per policy decision they have decided to specialise in Network Management Solutions. Earlier I was working with E-biz. As a whole I don't have any idea where DBA...

Hello Everybody I am working as Oracle DBA in an organisation which specialises in E-biz and Network Management Solutions. Now as per policy decision they have decided to specialise in Network Management Solutions. Earlier I was working with E-biz. As a whole I don't have any idea where DBA...

Hello Friends This may not be a question related to this forum but since I have been a member of this for a long I would like to ask this. Currently my organisation has divesified and took projects related to Network Management and product development for Networks. Since earlier I was working...

'Select * from user_indexes' will not serve purpose rightly as it will display all the columns unncessarily. Instead of this you can use USER_IND_COLUMNS. It looks like you know the index name , the table and column name can be found in this view. For other details see the USER_INDEXES view. I...

Well I know these files are used for a rollforward operations in recovery. Please tell me can I delete those files at the end of day because I am not using I am currenlty on just a desktop server which is used only for development, not for implementation Amol New to dba world, so please ......

Hello Friends I have a query related to backups and recovery operations. I am currently operating windows Nt Server with Oracle 8i. I have set Database in ArchiveLog Mode with automatic archival enabled. I have set log_archive_dest_1 and 2 in 2 different drives. Now As I see In both the...

Hello I would like to know whether I can see history of users logged in in oracle for a past few days. Currently our oracle has installed at remote server and I am accessing it using database links from my local oracle. If I want to who has logged on 2 days back and for what time how can I know...

Hello Can anyone tell me how set oracle two tier architecure in oracle 8.1.5 on linux. I have installed it but do I have to make changes in any of the paramaters. A lot of people said me that for effective connection pooling and processes handling for a B2B database two-tier will be more useful...

Thanks Michael Well I think my knowledge was wrong in this case, which was from some other book, Because I got some responses from some other forums that there is no such limit of 300. Depending on youe RAM and other resources you can increase this limit to more. Thanks Again for your...

Hello Everybody I don't know how to implement Multi threaded Server for a B2B database. Do I have to Install Oracle Again for it or can I change it by adding some parameters. Is there any other way which I can really have the solution to the problem of connection pooling from the database side...