ORA-

ORA-32774: more than one file was specified for bigfile tablespace

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-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-5cbe712263caa844023505/] 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 ...

Page 1 of 1012345...10...Last »
Skip to toolbar