• March 28, 2006 28 Mar'06

    Code to check password and display user-defined message

    When a particular user logs on to any schema, what code is to be written to check if the password is correct or wrong and display a user-defined message?  Continue Reading

  • March 28, 2006 28 Mar'06

    Defining object classes in C++

    Can I define object classes and tables from the object classes for use with OCCI in C++, which contain character strings, binary integers and binary floating point numbers, and which will be initialized and saved from the C++ program, but can also ...  Continue Reading

  • March 28, 2006 28 Mar'06

    Transferring a user and its tables to another installation

    I'd like to transfer an Oracle user with its tables to another Oracle installation (from Oracle system a, 8.1.7, to Oracle system b,, via Oracle client So the result should be all tables and their rows. What is the best way to...  Continue Reading

  • March 28, 2006 28 Mar'06

    Cause of ORA-01830 error

    I have two users who are getting the error "ORA-01830: date format picture ends before converting entire input string." Looking at the output from the precompiler, the code looks correct. My only assumption is that the strings comprising the date ...  Continue Reading

  • March 28, 2006 28 Mar'06

    Calling stored procedures in SQL Server to insert data in Oracle

    I have two DB servers: one is SQL Server, the other is Oracle. I need to call some stored procedure in SQL Server in order to insert some data in Oracle. How I could do that?  Continue Reading

  • March 28, 2006 28 Mar'06

    Intermittent dblink error for insert

    An intermittent Oracle dblink error for an insert is occuring early in the week. After it generates an error, it starts working again on its own after the error occurs. I don't know if this is affecting the dblinks, but a cold Oracle backup occurs ...  Continue Reading

  • March 28, 2006 28 Mar'06

    Partitioned vs. non-partitioned tables

    I'm attempting to address some performance issues by using list partitioning. As an experiment I created two small tables (with about 1,000 rows) of vehicle maintenance data, one with no partitions and the other partitioned by vehicle type. Queries...  Continue Reading

  • March 27, 2006 27 Mar'06

    Slow for loop cursor

    I have three tables, A, B and C. Table A has 450,000 records, and B has 80,000. I have created a for loop cursor on table A and check B in that loop. If a record is found in B then I want it to be inserted in table C. But I waited eight hours for ...  Continue Reading

  • March 27, 2006 27 Mar'06

    Improving performance of inserts

    First we read records from three different tables and insert into a temp table. From the temp table I fetch the records one by one, do some calculations and insert into another table if the record is new. If it already exists then I update the ...  Continue Reading

  • March 27, 2006 27 Mar'06

    Slow "create table" statement

    I have two servers; one is Oracle on Unix, the other is Oracle on Windows. I tried this SQL command: "create table xx as select * from table1@server2." This statement is very slow (43 seconds), but the query is very fast (0 to 1 ...  Continue Reading

  • March 27, 2006 27 Mar'06

    Database fully utilized with hang

    Our database is Oracle running on Linux AS 3.0. Our database is around 110GB and has 16GB RAM. Even though we have set the parameters in SGA_MAX_SIZE to 12G, shared pool size as 2G, db_cache as 4G and pga_aggregate as 800m (changed to ...  Continue Reading

  • March 24, 2006 24 Mar'06

    SQL for joining two tables

    What is the SQL statement that can be used to join two tables?  Continue Reading

  • March 24, 2006 24 Mar'06

    What happens when we fire a DML statement?

    I want to know when we fire a particular DML (delete) statement, what are the different activities that happen inside Oracle? For instance from user session to server session, then role of dbbuffer, redo buffer, and so on through redo log files and ...  Continue Reading

  • March 24, 2006 24 Mar'06

    Exporting 9i users/tables using 10g's exp utility

    Is there any way of exporting Oracle9i database users/tables using Oracle 10g's exp utility?  Continue Reading

  • March 23, 2006 23 Mar'06

    ORA-00904 with database link

    I've created a database link between a 9i and 8i database. It works but the same SQL in a PL/SQL block fails with "ORA-00904 : COL4 : identificateur non valide."  Continue Reading

  • March 23, 2006 23 Mar'06

    Last value in group

    I would like to get the last value within a group in the Oracle GROUP BY query. I can't use MAX(VALUE) as I need the most recent value in the group.  Continue Reading

  • March 23, 2006 23 Mar'06

    Package does not exist after batch job runs

    A developer batch job runs every Wednesday at 8 pm. It calls a package and runs for about an hour. The package exists for the whole week until this batch job is run, and come the next morning, when it's called again by other processes during the day...  Continue Reading