FAQ Database Discussion Community


Oracle Tablespaces maxsize “unlimited” not really unlimited

oracle,oracle11g,tablespace
I recently needed to import a .dmp into a new user I created. I also created a new tablespace for the the user with the following command: create tablespace my_tablespace datafile 'C:\My\Oracle\Install\DataFile01.dbf' size 10M autoextend on next 512K maxsize unlimited; While the import was running I got an error: ORA-01652...

How to export oracle 11g user to 10g and on a different default tablespace

oracle,oracle11g,tablespace,impdp
I have an 11g database and I want to export a dump to import it later on a 10g database. I can use expdp with option VERSION=10.2 but my problem is that I have to import this dump on a different tablespace. thank you ...

Error committing Oracle tablespace in Docker

oracle,docker,tablespace
I tried to "docker commit" the tablespace I created on a container that is based on alexeiled's oracle xe 11g container. But I got this error: FATA[0027] Error response from daemon: ApplyLayer exit status 1 stdout: stderr: write /u01/app/oracle/oradata/XE/usr.dbf: read-only file system Why is it trying to write usr.dbf to...

Is it safe to add a datafile to a tablespace which is being used by a index which is currently in the process of creation?

oracle,indexing,database-administration,tablespace,data-files
The situation is that I ran a create index query on a table (index type ctxsys.context) about 36 hours ago. The tablespace it refers to has 128gb allocated (4x32gb datafiles). As per latest situation the index is still in progress of being built however it has already taken up 100gb...

Oracle XE data limit reached - how to reduce tablespace size?

oracle,oracle11g,resize,tablespace,data-files
I have an Oracle XE database with several tablespaces. One of these is used to store image data, and this tablespace has grown to a huge size. We decided that we didn't need to the images any more so deleted them all. This has freed up a lot of space...

How can I delete the users datafile in Oracle using SQL?

oracle,ddl,tablespace
I have tried dropping the datafile by itself but I get this error. SQL> alter tablespace USERS drop datafile '/u01/app/oracle/oradata/orcl/users01.dbf'; alter tablespace USERS drop datafile '/u01/app/oracle/oradata/orcl/users01.dbf' * ERROR at line 1: ORA-03261: the tablespace USERS has only one file I have also tried taking the tablespace offline and dropping the...