Hi !I have some questions regarding Oracle Reports. Please reply if you know. a) How can we call oracle reports from a Java Frame ?b) Can we send an oracle...
This is not a job, but an answer for some of us that used to have a 9 to 5 full time job In Corporate America with full health care benefit and more. However,...
Hi All ! IS there a way to check the validity of the archive log files . Like we can use db_verify to check for the validity of the data files . What about for...
Amith Uppal
uppal_amith@...
May 13, 2003 6:52 am
335
Hi Amith, I think, RMAN will check the validity of archive logs files while backup. Thanks Sameer ... From: Amith Uppal [mailto:uppal_amith@...] Sent:...
Sameer Wadhwa
swadhwa@...
May 13, 2003 2:00 pm
336
Hi Amith, I think, you can use db_block_checksum = true to ensure , the corruption is detected at the time of creation of archive log files, as well as...
Rajesh Arora
arora_rajesh@...
May 13, 2003 2:24 pm
337
Hi All ! In unix shell scripting , even if we prompt for username / password , it will still display in the ps command . I need a way to get rid of this . I...
Amith Uppal
uppal_amith@...
May 14, 2003 11:57 am
338
If I undestand you correctly, you are prompting for user/pass at the shell script level and passing them to SQLPlus. Instead of read USER read PASS sqlplus...
Hi Amith, Here is a script I saved long time ago. Take a look at it. It should hide the arguments passed to sqlplus(including username/password), & hides it...
Rajesh Arora
arora_rajesh@...
May 14, 2003 2:03 pm
340
Hi all ! That was very helpfull ! Amith Rajesh Arora <arora_rajesh@...> wrote: Hi Amith, Here is a script I saved long time ago. Take a look at it. It...
Amith Uppal
uppal_amith@...
May 15, 2003 3:51 am
341
Hi All, I am having a 9i database which is frequently crashing with the above message.The alert log shows the message as below. Errors in file...
Hi, I have application which use JSP at front end and oracle 8.1.7 at back end. I keep getting error which is java.sql.SQLException: ORA- 01000: maximum open...
Some thought on this . Whats the value of your init parameters ? cursor_sharing cursor_space_for_time Also when u close the web page , do u actually close all...
Amith Uppal
uppal_amith@...
May 16, 2003 4:08 am
345
Guys , I am looking for a generic script to generate alerts if any segment reaches the maxextents threshold . The segment type can be rollback , table , index...
Amith Uppal
uppal_amith@...
May 16, 2003 11:16 am
346
Hi Amith, cursor_sharing = EXACT cursor_space_for_time = FALSE I am using connection pool for my web pages. Usually, I close connection and it will close all...
Amith, I do not know, whether you are looking for the sql statement or the monitoring script. Here is a simple sql statement, you can expand of it for your...
Rajesh Arora
arora_rajesh@...
May 16, 2003 3:35 pm
348
Hi Sameer, All the file status and tablespace status are available and online respecitively. I made a file renaming to different partition and started the ...
hi all Please I need for yor Help very much I am going to 1z0-123 Architecture and Admin next week 1Z0-123 I am using testking ver1.0 for this exam can any one...
Sorry if this is a basic question. I am trying to pupulate a table which has a collumn called 'CONFIRM_YN'. When I try to insert data into this table I've...
What is your insert statement? What is the data type of the column? What's the error message? On Sat, 31 May 2003 02:11:09 -0000, "matthous2003" wrote: Sorry...
Dear Steve, Thanks very much for taking the time to help me on this one. The table was created as follows: CREATE SEQUENCE POR_SEQ INCREMENT BY 1 START WITH...
I think the problem is your date. It should be in quotes insert into purchase_order (POR_ID, POR_DATE, SUP_ID, VALID_UNTIL_DATE, CONFIRMED_YN) values (1,...
Hi all I send My First Message at you Group Subject <Please Help me > But still Now One Whant to help Me Please I need Test King For Exams <1z0-023> &...
Thanks very much for your help. It now works perfectly. ... to_date ... never rely ... at the ... 2003', 'N') ... work, but ... differences between ... yur...
Sorry, that was meant to be a thank you to both Steven and Michael. I very much appreciate both of you taking the time to help. I'm new to this Oracle stuff....
Hoped not to bother you with any more qq on this task! Oracle tells me that I have a missing comma in the 'values' part. I've looked for ages but I just can't...
Thanks for your speedy reply. In fact the date was only wrapped in the message I posted (although I had put the first part on one line and then from...
Oh! You are missing the closing ")" at the end of the ...values (1, 1, 1, 20, 15, 15, 15, 5.80, to_date('15-JUN-2003','DD-MON-YYYY'); should be ...values (1,...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
