Error creating table space

Create Table Space for TBS_USER_IDX

create tablespace TBS_USER_IDX                  
datafile'C:\app\oracle\oradata\orcl\TBS_USER_IDX.dbf'size 128m                    
autoextend on next 16m maxsize 1024m;

The error is

 ORA-01119: Error creating database file 'C:\app\oracle\oradata\orcl\TBS_USER_IDX.dbf'.
ORA-27040: Error creating file, unable to create file
error in creating database file '%s'"
*Cause—Usually due to not having enough space on the device.

What should I do?

sql oracle

2022-09-30 19:27

2 Answers

The following steps have been used to resolve the issue.

This post was posted as a community wiki based on @user25636's comments.

2022-09-30 19:27

The error message can be read as "Do you have enough free space?" but it is just an example of the cause.There are other possible reasons why the file cannot be created, so check the following:

Do you have enough free space?
- If there is no free space, increase the free space or change the creation location to a free file system.
Do you have a directory to place physical files in?
- Create the directory if it does not exist.
Does the directory where the physical files are placed (also the ancestor directory) have permission to access the user performing the processing?
- Give permissions to the users you want to run
- Run with authorized users

If there is no free space, increase the free space or change the creation location to a free file system.

Create the directory if it does not exist.

Give permissions to the users you want to run
Run with authorized users

2022-09-30 19:27

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656