| database tablespace [message #58569] |
Wed, 17 September 2003 22:54  |
I Ketut Partajaya
Messages: 1
Registered: September 2003
|
Junior Member |
|
|
Dear all,
Iam beginner,
Is it possible to make different database with the same tablespace?
someone told me to create only USER_DATA and TEMPORARY_DATA tablespace for different database.
please help.
Thank in advance
|
|
|
|
| Re: database tablespace [message #58577 is a reply to message #58569] |
Thu, 18 September 2003 08:32  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
You mean you want to create a new database whose tablespace NAMES are the same as an existing database ?
Certainly YES.
A tablespace is specific to a database and cannot be shared normally across different databases. I hope you are not talking about transporting tablespaces or mounting Read only tablespaces.
You will need to create the required tablespaces(be it for DATA , Index, Rollback segments/UNDO,Temporary segments,USERS,Tools etc etc) in every database ,as seem fit.
Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
