Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. madhes

    how to get client version?

    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...
  2. madhes

    Inserting lengthy char data

    Thanks Sem!
  3. madhes

    Inserting lengthy char data

    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
  4. madhes

    Inserting lengthy char data

    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...
  5. madhes

    Scrollable Resultsets: SENSITIVE Vs. INSENSITIVE

    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...
  6. madhes

    Enabling Supplemental logging.

    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...
  7. madhes

    Executing LogMiner for scanning the Archive Logs.

    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...
  8. madhes

    Oracle9i: Problem with logging a Timestamp value.

    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...
  9. madhes

    Problem with logging a Timestamp value.

    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...
  10. madhes

    Oracle9i: Problem with logging a Timestamp value.

    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...
  11. madhes

    How to drop an ARCHIVED-LOG file.

    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...
  12. madhes

    How to drop an ARCHIVED-LOG file.

    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...
  13. madhes

    How to drop an ARCHIVED-LOG file.

    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...
  14. madhes

    Open transaction in ARCHIVED_LOG files?

    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...
  15. madhes

    Open transaction in ARCHIVED_LOG files?

    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...
  16. madhes

    Overflow Handling in Java

    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...
  17. madhes

    Overflow Handling in Java

    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...
    • madhes
    • Thread
    • Replies: 2
    • Forum: Java
  18. madhes

    'Too many files open' error. is there any limitation by JVM?

    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...
    • madhes
    • Thread
    • Replies: 0
    • Forum: Java

Part and Inventory Search

Back
Top