ORA-01119: error in creating datafile | Karan Rajpoot

In this article you will get to know how we can resolve ORA-01119: error in creating datafile which occur at the time of database file creation in oracle.

 

Error: – ORA-01119: error in creating a datafile

Cause: – Datafile size has not mentioned in the datafile creation command.

Solution: – Mention the datafile size at the end of the command and re-execute it. 

 

Example: –

 
SQL> alter tablespace users add datafile ‘/u01/app/oracle/oradata/prod/users02.dbf’;
alter tablespace users add datafile ‘/u01/app/oracle/oradata/prod/users02.dbf’
*
ERROR at line 1:
ORA-01119: error in creating database
‘/u01/app/oracle/oradata/prod/users02.dbf’
ORA-17610: file ‘/u01/app/oracle/oradata/prod/users02.dbf’ does not exist and
no size specified
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Note: – In the above command datafile size has not mentioned at the end of the command, Put the datafile size and re-execute command again like below
SQL> alter tablespace users add datafile ‘/u01/app/oracle/oradata/prod/users02.dbf” size 50m;

Hope this blog will help you!!

If this article is useful for you please comment, share with your friends.

In case of any issues please send your query to below comment section.

For more articles please do visit below links: –

ORA-12899: value too large for column | Karan Rajpoot

ORA-12899: value too large for column | Karan Rajpoot

If you want to download Oracle virtual box or VMware Workstation Player, Please click on below links:-

Oracle Virtual Box

VMware Workstation Player

This Post Has One Comment

Leave a Reply

Close Menu