Search results for query: *

hi I need to find out what is the version of the client that is installed on a machine. From "Help" -> "Product Information" (of Control Centre) I couldnt get the complete version info. It just said, "7". I need to make sure whether its 7.01 or 7.1 or 7.2. Also, pls help me to find out the...

Thanks Sem!

Oh! thanks a lot Sem! It works fine. but, still i need to type 2000 characters. In case if want to insert some junk value, is there way to tell "put '#' 2000 times" ? thanks, madhes

Hi, I need to insert a lengthy text into the columns of a table. The format of the table is int, char(2000), char(2000). When i insert using the following statement, &quot;insert into t1 values (1, <2000 characters>, <2000 characters>)&quot;, it gives the following error: &quot;SP2-0027...

Hi, Just i was reading the JDBC Tutorial @ java.sun.com and when i read the following statement i was bit confused, what they really meant? &quot;Generally speaking, a result set that is TYPE_SCROLL_INSENSITIVE does not reflect changes made while it is still open and one that is...

Hi, We need to enable the supplemental logging for Oracle 8i tables. This is used to tell Oracle, what are all the columns should be logged when the DMLs are performed. This can be done in 9i, using the following commands: Database level: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY...

I m using LogMiner for scanning my archive logs. I use following sequence: 1. Get a connection for LogMiner session. 2. Add the required log files to the LogMiner session. 3. Start the LogMiner, using DBMS_LOGMNR.START_LOGMNR(...). 4. Read from the view V$LOGMNR_CONTENTS, using a select query...

Thanx. Yep! I agree that i should have posted this in 9i forum. (I just did that). And regarding the format i ve given here, is a valid format and after setting this format, the NLS_SESSION_PARAMETER contains this format and when I select the values from the table, it prints the timestamp...

Hi, I have a table in Oracle9i, with a timestamp column. >> create table t1 (ts TIMESTAMP); I used to enter the data as follows, >> alter session set NLS_TIMESTAMP_FORMAT='yyyy-mm-dd hh:mi:ssxff'; >> insert into t1 values (to_timestamp('2002-08-15 10:10:37.123456')); The format i have set...

I have a table in Oracle9i, with a timestamp column. >> create table t1 (ts TIMESTAMP); I used to enter the data as follows, >> alter session set NLS_TIMESTAMP_FORMAT='yyyy-mm-dd hh:mi:ssxff'; >> insert into t1 values (to_timestamp('2002-08-15 10:10:37.123456')); The format i have set here...

Okay! My exact requirement is something like this: I need to read all the log files and apply the same statements on another target database. For this I use, LogMiner utility provided by Oracle. Before starting a logminer session, the log files that are need to be analysed have to be added with...

Thanks. But, i wanted to delete that file name from the view too. Because, from a Java program, i m accessing those files, after reading their names from that view. So, i ll get an IOException, saying that FileNotFound. :( So, i need to delete that file-name entry from the view. Pls suggest...

Hi, I want to drop/delete an archived-log file from an instance. we can see the list of online and archived log files from the views, V$LOGFILE and V$ARCHIVED_LOG respectively. Oracle supports dropping an online log file using the foll. statement. ALTER DATABASE DROP LOGFILE 'file-name'; But...

Oops! I did a small mistake, in my question. I was asking about the completed transactions. (Those may be COMMITTED or ROLLEDBACK). I just want to confirm, whether the all statements belonging to a completed transaction might sit in a single REDO log file. I believe, as Karluk notified, they may...

Hi, I just want to confirm whether ONLINE and ARCHIVED log files contain only the completed (COMMITTED) transactions. Or whether they may have open transactions? For example, assume a given transaction that contains 10 statements (combination of INSERT/UPDATE/DELETE). Now, is this possible...

Thanks. The results are casted to the upper types, for only byte and short. If the operands are of integer types, the result will be again an integer, & compiler will not throw any error. Since we use int and long in our applications widely, i need a mechanism to detect the overflow. Consider...

Hi, Is there any direct way to find, whether overflow occured in a computation, in Java. For eg., assume the following code segment: byte a = 10, b = 120, c = a + b; here, overflow occured and 'c' wil have a wrong value, instead of 130, (since a byte can hold only upto +128). I just want to...

Hi, When I m opening a large number of files (approx 2040) and i m getting the following exception. &quot;java.io.FileNotFoundException: d:\temp\SortComponentFile2677.sort (Too many open files)&quot; I want to know, whether JVM puts any limitation on the number of files that can be opened? Is...