Mvs
Reputation: 21
Is it possible to create tablespace in existing datafile in Oracle?
Now I have created 1 tablespace named work_schema and datafile named schema.dat. And I need to create one more tablespace called assign_schema and I would like to use same schema.dat file. Is this possible?
Upvotes: 0
Views: 2653
Answers (1)
Simon
Reputation: 4475
No, due to the way Oracle Logical Storage Structures work (see the Oracle Concepts guide), there is no way of using the same datafile for two tablespaces. Each tablespace has to have its own datafile(s).
Upvotes: 2
Related Questions
- SYSAUX tablespace with non existing datafile
- Are data files required when creating tablespaces in Oracle?
- ORACLE Database | remove tablespace with missing datafile
- CREATE and DROP TABLESPACE Oracle
- How to add the datafile to tablespace which is already full?
- How to create a tablespace with multiple datafiles?
- oracle database, error in adding datafiles to an existing tablespace
- Specify the datafile to create a table partition In a tablespace spanning multiple datafiles
- Can oracle tablespaces automatically add smallfile datafiles?
- Reuse existing space in tablespace files (ORA-01658: unable to create INITIAL extent for segment in tablespace USERS)