FAQ Database Discussion Community
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...
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 ...
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...
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,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...
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...