• April 27, 2006 27 Apr'06

    Logging changed vectors during DMLs

    Is there any way to prove that during a user-managed hot backup, the first DML in the session logs the entire block image as well as the changed vectors, while logging only the changed vectors during subsequent DMLs?  Continue Reading

  • April 27, 2006 27 Apr'06

    Can I take a compressed backup with RMAN?

    I am using RMAN for my backups. But it failed. The reason is the size of the backup -- the filesystem got filled before it started compressing the backup files. Is there any way I can take a compressed backup?  Continue Reading

  • April 27, 2006 27 Apr'06

    Export failing with EXP-00002

    I'm having trouble with exporting using the Oracle 8.1.6 export utility to export tables from an Oracle database. These exports are part of a bill close we do every month and have been working fine for about a year. Now suddenly the ...  Continue Reading

  • April 27, 2006 27 Apr'06

    Oracle beefs up database security at Collaborate '06

    Oracle's new Database Vault and Secure Backup offerings promise to make it easier to avoid internal threats and automate disk-to-tape backup. SearchOracle.com talked to Oracle's Mark Townsend at Collaborate '06 in Nashville to find out more.  Continue Reading

  • April 25, 2006 25 Apr'06

    Open source EnterpriseDB takes aim at Oracle customers

    In an interview with SearchOracle.com, Andy Astor, EnterpriseDB's president and chief executive officer said his firm hopes to lure Oracle customers over to the open source world.  Continue Reading

  • April 21, 2006 21 Apr'06

    Using a pre-existing list

    I'm attempting to write a query against a table (Table_A) which has three columns. I have a pre-existing list that I'm attempting to bounce off my table. I want, however, all of the names in my pre-existing list to appear in my results. If the ...  Continue Reading

  • April 21, 2006 21 Apr'06

    Best HA and OS options for data warehouse

    We are researching HA options and due to budgeting, the project is looking at migrating to a Dell Linux Oracle RAC environment. One of the databases on the Sun Solaris system is our data warehouse (OWB). My question: What are the best OS and HA ...  Continue Reading

  • April 21, 2006 21 Apr'06

    Using roles/grants vs. public synonym

    I created two users, U1 and U2, then created role R. I created tables in user U1 and gave grants to select, insert, update and delete to role R. I assigned role R to U2. Now if I log in through user U2 then I am able to see all objects of user U1. I...  Continue Reading

  • April 21, 2006 21 Apr'06

    SQL statement gets very long very fast

    I have the following SQL statement. I now need to substitute pkColumn in that statement with a composite primary key of, let's say, two integer columns. The problem, besides performance issues, is that the statement gets very long very fast and ...  Continue Reading

  • April 21, 2006 21 Apr'06

    ORDER BY a specified sequence

    I'm trying to create an SQL query with the IN clause where I give the IDs to match. Now I want the order of these records to be the same as I give in the IN clause. But it's not happening.  Continue Reading

  • April 21, 2006 21 Apr'06

    Can't get data with synonym name

    I created a public synonym with the same object name to allow me to refer to that object without prefixing the schema name, and I gave a select insert and update grant to public on that object, but I still can't get the data by using the synonym ...  Continue Reading

  • April 21, 2006 21 Apr'06

    Multiple SIDs in same database?

    Can I create multiple Oracle SIDs in the same Oracle database or do I have to create a different SID using DBCA?  Continue Reading

  • April 21, 2006 21 Apr'06

    Is Oracle easy to learn?

    Is Oracle easy to learn? I am creating an information system using Visual Studio and Microsoft Access. I chose MS Access as it is not based on a command language whereas Oracle is. Also Access has a GUI whereas Oracle does not, correct? I'm a bit ...  Continue Reading