For more information about the site, see the Site Index

• Storing multimedia data
• Reading Reports 3.0 .pdfs without the PDF Writer/Distiller
• Triggers not working after export from user X to user Y
• Creating a view from a 3-table join
• Migrate/copy database to another server
• PL/SQL functions returning a string longer than 32767
• Modeling tools that support DB2 and forward/reverse engineering
• Time-based stored procedure to check table and update old records
• Getting a row number in a group
• Should unrelated data marts be on the same instance?
• Scripts for NT to delete archived Oracle scripts
• Can I write code using VB editor to query MS Excel VBA?
• Tool to transfer DB objects from Oracle 8i to SQL Server
• Deadlocks occuring when many transactions on same tables occur simultaneously
• Total size of SGA greater than what was allocated
• Cube and vertical partitioning explained
• Transactions per second in 8.1.7
• Using Table 2 values for Table 1 when column names are the same
• Important configuration parameters for Oracle on Solaris
• Paging without running a query a second time?
• "mydatabase" and database links
• Loading LONG RAW data
• Which components are installed in the database?
• Starting instance automatically on W2K
• When to build the data warehouse: before or after designing application database?
• SQL versus stored procedures
• Logging failed trigger, automatically trying again
• Is a DOS platform database required to store huge amounts of data?
• Can't open .dmp file
• How to upgrade to 8.1.7
• Where session-specific SQL is executed
• Resolving ORA-4091
• Oracle9i as a CAD database
• Importing data into different tablespace with a different user name
• Schema-based backups
• Query to find size of BLOB objects
• Root script logging in as system then altering password: bad practice?
• Separating 8i, 9i listeners installed on same machine
• Determining instances for a data mart
• Scheduling a query
• Strategies for data backup for terabytes of data
• AS versus IS
• Problem installing Oracle on Red Hat Linux
• Grouping output by week
• Inserting multiple child rows
• Many-to-many links that aren't there
• Paging through a result set without TOP or LIMIT
• Oracle licensing explained
• Setting up automatic e-mail notification of expiring passwords
• Migrating from Sybase to Oracle with SQL*Loader
• Finding users and their network addresses
• Error with tnsping test
• Error using JDBC to query local database
• Why isn't my cursor returning any rows?
• Why logs shouldn't be put on RAID devices
• Cleaning up older Oracle stuff before upgrading
• Oracle equivalent of LIMIT and OFFSET to get nth row
• Months between two dates in Oracle
• Exporting table in a ebcdic character set and comp-3 format
• Importing and exporting a database from a remote machine
• Changing the datatype of a column in 8.1.7
• Aggregates with associated detail values
• Textcopy.exe and Oracle 8i
• Uploading an Excel file into the database
• Updating a table with values from another
• Exactly one row? At least one row? (Part 2)
• What does SELECT 1 accomplish?
• Purpose of a primary key
• Inserting three columns into one
• Grouping on the date part of a datetime column
• What version of HP-UX is the best for Oracle 9i/Oracle 9iAS?
• SAN and cluster file systems
• Exactly one row? At least one row? (Part 1)
• Using FTP to transfer text files spooled from an SQL statement
• Creating ODBC applications
• Starting archive log mode
• Importing a dump file from a higher version
• New or composite primary key for a composite table?
• Setting up a recovery catalog
• Using DISTINCT on two fields
• Listener could not solve the SID given in connect descriptor
• Inserting one million rows
• Extracting processes taking longer and longer
• Questions about procedures, packages and functions
• When is temporary tablespace used?
• Trigger to restrict number of rows in a table
• Loading text files into Oracle tables
• Beyond petabytes
• Objects feature not enabled
• Need to worry about datafiles when upgrading OS?
• Updating two different databases with the SQL UPDATE method
• What to do as the only Oracle DBA in the company
• A data-driven solution to changing expression when criteria change
• Looking for info on Sybase PowerStage and PowerDimension tools
• Deciding between type 1 and type 2 dimensions
• Query to get user information
• Inserting a carriage return in an Oracle table
• Mutating table error with "NEW" bind variable
• Business user involved with data warehouse project
• Can we estimate maximum rate data can be loaded?



• More