Oracle ORA-14074 Create or Add New Partition Fails Error
Oracle database partition is a division or decomposition of a logical database and/or its constituting elements (indexes or [...]
Change Oracle Database User Password
To ensure security of the Oracle database system and prevent unauthorized access to the Oracle database, it's important [...]
Create New Table by Selecting Data from Other Tables with CREATE TABLE AS
By using SQL data manipulation statement, a new, temporary, backup or regular table can be created and filled [...]
ORA-02449 Oracle Drop Table Error
Sometimes when dropping a table in Oracle database by executing DROP TABLE SQL statement, Oracle may return the [...]
IMP-00016 Required Character Set Conversion Not Supported Error when Import to Oracle Database
When trying to import an Oracle database export, backup or dump, you may encounter the error IMP-00016 where [...]
Oracle EXP-00091 Error When Export Database
When trying to do a Oracle database dump or export, be it full entire database export or a [...]
View and Retrieve Oracle Database Link Details
In Oracle, database links are named objects that are created in one database which contains detail and instruction [...]
IMP-00013 Oracle Import Error
When trying to import an export dump file that has been exported by a DBA, the following error [...]
ORA-01502 Oracle Index in Unusable State
When trying to perform query on Oracle tables with select SQL statement, Oracle returns the following error: ORA-01502: [...]
ORA-25153 Temporary Tablespace is Empty Error in Oracle
When executing SQL query, the following Oracle error may appears: ORA-25153: Temporary Tablespace is Empty The cause for [...]