PROBLEM: While creating bigfile tablespace with multiple datafile, got error as ORA-32774: more than one file specified SQL> create bigfile tablespace BIGTS datafile ‘/dmdata02/oradata/BSDMSI...
ORA-
ORA-32773: operation not supported for smallfile tablespace
PROBLEM: While enabling autoextend for an tablespace, got error like ORA-32773: operation not supported for small file table space. SQL> alter tablespace SMALLTS autoextend on; alter tablespace SMA...
ORA-01536: space quota exceeded for tablespace
PROBLEM: While creating a table or inserting data, user is getting error ORA-01536: space quota exceeded for tablespace . [crayon-5c998c5d5b4c6816371154/] SOLUTION: Tablespace quota is the storage all...
ORA-02304: invalid object identifier literal while import with CREATE TYPE OID
PROBLEM: While importing schema objects, got below errors. ORA-39083: Object type TYPE:”PADADM10″.”NAME_AND_COUNT_ARRAY” failed to create with error: ORA-02304: invalid objec...
ORA-01950: no privileges on tablespace ‘USERS’
PROBLEM: While creating a table using CTAS, got an error, ORA-01950: no privileges on tablespace ‘USERS’. SQL> create table DBACLASS.EMPLO as select * from user_objects; create table E...
ORA-09925: Unable to create audit trail file
PROBLEM: Users are getting below error, while trying to connect to the database. ERROR: ORA-09925: Unable to create audit trail file Linux-ia64 Error: 28: No space left on device Additional informatio...
ORA-00257:archiver error, connect internal only until freed
PROBLEM: Application log shows below error and users are unable to connect to the database. 0RA-00257:archiver error, connect internal only until freed ORA-16014:log 1 sequence# 280 not archived, no a...
ORA-01541: system tablespace cannot be brought offline; shut down if necessary
PROBLEM: DBA is planning to move the system database file to a new location, for which he tried to make the system tablespace offline. SQL> alter tablespace system offline; alter tablespace system ...
ORA-01994: GRANT failed: password file missing or disabled
While granting SYSDBA role to a database user, got below error. SQL> grant sysdba to DEV_DB; grant sysdba to DEV_DB * ERROR at line 1: ORA-01994: GRANT failed: password file missing or disabled SOL...
ORA-01441: cannot decrease column length because some value is too big
PROBLEM: While decreasing length of a column using alter statement, got below error. SQL> alter table dbatab modify ( dbaname varchar2(5)); alter table dbatab modify ( dbaname varchar2(5)) * ERROR ...