Ask the Experts

Ask the Experts

• Design advice for 2 TB database

  Kindly advise me on the design of a database sizing around 2 TB per month on transaction table.  Continue Reading

• How to move tables from system tablespace to user tablespace

  I want to move a few tables from the system tablespace to a user tablespace. I have some data on the tables, and I also have some user privileges. I want to retain both.  Continue Reading

• Varchar or number for better performance?

  Which one is better for performance as a unique index, varchar or number?  Continue Reading

• LAST_OPER_TYPE column in v$sga_dynamic_components

  Why does the LAST_OPER_TYPE column in v$sga_dynamic_components always contain the value INITIALIZING for the "DEFAULT 16K buffer cahce" row?  Continue Reading

• Where to download Oracle 8.1.7 ProC compiler media

  I need the 8.1.7 ProC compiler. We do not have the media. Tried 8.1.5 ProC and it did not work. Can you direct me to sources that may have the media for purchase/download?  Continue Reading

• Moving from rollback segments to undo tablespace in Oracle 10g

  We are using rollback segments in an Oracle 10g database. We would like to move from using rollback segments to the undo tablespace.  Continue Reading

• ORA-12560 error with Oracle 10g Instant Client

  I installed Oracle 10g Enterprise Edition on one computer, and the 10g Instant Client on another. When I try to connect from the other computer with I get an ORA-12560 (TNS protocol adaptor error).  Continue Reading

• Is it possible to assign a role to a profile?

  Is it possible to assign a role to a profile? Or can you only assign individual users to a profile?  Continue Reading

• How to start multiple instances in Oracle 10g

  I want to know how to start multiple instances in Oracle 10g. I have created two databases using DBCA and I have one database server.  Continue Reading

• Oracle certifications to get an Oracle DBA job

  In my country only a few companies/organizations have implemented Oracle. Thus Oracle-specific jobs are still quite rare and even when available only the experienced DBAs tend to get them.  Continue Reading

• Stringing together columns with UPDATE SQL

  Is it possible in T-SQL or PL/SQL to string together the values in a column grouped by another column?  Continue Reading

• Number of rows in multiple tables

  I need a query which will give the tablename and the count of the number of rows. Is it possible?  Continue Reading

• Stored procedure to autotransfer data between Oracle servers

  How to make a stored procedure to autotransfer updated data from a remote server to a central server?  Continue Reading

• Data exchange between Oracle 10g and 8i databases

  We have an Oracle 8i database connected to other 8i databases. If we upgrade it to Oracle 10g but leave the others at 8i, will there be any problem with the data exchange?  Continue Reading

• Add or drop inactive online redo log files

  Can we add or drop (inactive) online redo log files at the open stage?  Continue Reading