-
User vs. schema in Oracle
An Oracle user asks what the difference is between a user and a schema.
-
Is there any tool to migrate data from DB2 to Oracle?
Expert Brian Peasland talks about the Oracle Migration Workbench, which can migrate data from DB2 to Oracle.
-
Can I populate tables in MS ACCESS and upload to the Oracle server?
Database Design and Architecture expert Brian Peasland explains his procedure for populating tables in MS ACCESS and upload it to the Oracle server.
-
I have space in log_arch_dest, so why am I getting the ORA-00257 error?
An Oracle user asks why they are getting the ORA-00257 error even though they have sufficient space in log_arch_dest.
-
Does making an Oracle datafile READ ONLY after a backup change the file?
An Oracle user asks if making a datafile READ ONLY after a backup changes the file.
-
Why am I receiving the ORA-12535 error when using a remote database?
An Oracle user asks why they are receiving the error ORA-12535: TNS: operation timed out when using a remote database.
-
Partitioning a table in Oracle to improve performance
An Oracle user asks if partitioning a table will improve performance.
-
How to restore a database using RMAN to Point in Time
An Oracle user asks how to restore a database using RMAN to Point in Time.
-
Cold backups after SHUTDOWN ABORT
An Oracle user asks if a cold backup can be performed after closing the database with SHUTDOWN ABORT.
-
ORA-06550 error when importing a 10.2 dmp file into a 9.2 database
An Oracle user asks Database Backup and Recovery expert Brian Peasland why they are getting the ORA-06550 error error when importing a 10.2 dmp file into a 9.2 database.
-
Installing Oracle homes when upgrading
An Oracle user asks if there is any need to install two Oracle homes in two separate users when upgrading from 9i to 10g.
-
Defining RTO, MTBF and MTTR
Database backup and recovery expert Brian Peasland explains the terms RTO, MTBF and MTTR.
-
Managing temporary tablespace growth in Oracle
An Oracle user asks Database Backup and Recovery expert Brian Peasland about managing temporary tablespace growth.
-
Which normal form is used most?
SQL expert Rudy Limeback explains what normal form is used in most database projects.
-
Update a specific column in a field or row?
An Oracle user asks if SQL can be used to update a specific column in a field.
-
Using BETWEEN with DATETIMEs in SQL
Expert Rudy Limeback is asked if SQL can be used to retrieve data between two dates, including the two dates.
-
Finding a column value inside a user-supplied string
SQL expert Rudy Limeback explains how to find a column value inside a user-supplied string.
-
Remote database administration: What to look for in a provider
Managing an Oracle shop expert Michael Hillenbrand talks about his experiences with remote database administration.
-
Receiving the ORA-01652 error with no specified tablespace
An Oracle user asks why they are receiving the ORA-01652 error but there is no tablespace specified in the error.
-
Why am I getting the ORA-03113 error when trying to refresh a materialized view?
An Oracle user asks expert Brian Peasland why they are getting the ORA-03113 error when trying to refresh a materialized view completely.
-
Perfect the Oracle RMAN duplicate 10g command
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
-
Do SQL arithmetic without using arithmetic operations
Learn how to do simple SQL arithmetic operations without using the arithmetic operators.
-
Managing SQL parent table-child table relations
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Submit a question to our experts