Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
This is a discussion on dictionary managed tablespace within the Database Design forums, part of the Databases category; dictionary managed tablespace how to create a dictionary managed tablespace? i tried but only one is created that is the SYSTEM....
|
|||||||
| Database Design Disucss if you have any issues with Database Design and Concepts |
![]() |
| LinkBack | Thread Tools | Display Modes |
|
|||
|
dictionary managed tablespace
how to create a dictionary managed tablespace? i tried but only one is created that is the SYSTEM. |
| The Following User Says Thank You to kenith_shah01 For This Useful Post: | ||
| Sponsored Links |
|
|||
|
Re: dictionary managed tablespace
hai friend
create tablespace <tablspacename> datafile <'path/filename'> size 10m extent management dictionary; ex: create tablespace ts1 datafile '/disk1/oradata/db3/ts1.dbf' size 20m extent management dictionary; if u want customized dictionary tablespace example: create tablespace ts1 datafile '/disk1/oradata/db3/ts1.dbf' size 10m extent management dictionary default storage(initial 40k next 50 minextents 2 maxextents 20 pctincrease 40); |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Locally managed tablespace | jkrish.sharma | DB2 | 0 | 07-27-2008 08:01 AM |
| Difference between metadata and data dictionary | Diamond Sowjanya | Data Warehousing | 3 | 07-09-2008 04:54 PM |
| Can exp just export a tablespace | orion42 | Oracle | 1 | 09-26-2007 01:55 PM |
| Real Time scenarios of Using Hashtable and Dictionary classes | Geek_Guest | Java | 0 | 04-15-2007 05:23 AM |