- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: editing .ora files
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-30-2003 07:54 PM
тАО11-30-2003 07:54 PM
Re: editing .ora files
How about your SYSTEM tablespace?
If your system tablespace is created as locally managed, you can't create any dictionary managed tablespace.
Using the following SQL to see the details:
select * from dba_tablespaces where tablespace_name='SYSTEM';
regards
twang
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-30-2003 07:59 PM
тАО11-30-2003 07:59 PM
Re: editing .ora files
I'm new to SQL as well.
How can I modify the SQL statements to conform to my system
I actually have 8 examples I need to follow. 4 to create tablespaces, a few others to create users, report role, and granting report role priviledges.
Thanks
-Alvi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-30-2003 09:01 PM
тАО11-30-2003 09:01 PM
Re: editing .ora files
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
TEMP
CWMLITE
DRSYS
EXAMPLE
INDX
ODM
TOOLS
USERS
XDB
11 rows selected.
and another not so readable
SQL> select * from dba_tablespaces where tablespace_name='SYSTEM';
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
----------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN
--------- --- ------
SYSTEM 8192 65536 1
2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL
SYSTEM NO MANUAL
Regards,
-Alvi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2003 12:03 AM
тАО12-01-2003 12:03 AM
Re: editing .ora files
ORA-12913 Cannot create dictionary managed tablespace
Cause: An attempt was made to create a dictionary managed tablespace in a database whose SYSTEM tablespace is locally managed.
Action: Create a locally managed tablespace.
When creating tablespace you have to use extent management local.
greetings,
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2003 12:27 AM
тАО12-01-2003 12:27 AM
Re: editing .ora files
Following are three different cases of the statements.
SQL> create tablespace visionael_tempspace
2 extent management local
3 datafile 'c:\oracle\oradata\orak\orak_tmp01.dbf' size 10 M
4 autoextend on next 10M
5 default storage (
6 initial 50K
7 next 50K
8 minextents 1
9 maxextents 121
10 pctincrease 10
11 ) temporary online;
create tablespace visionael_tempspace
*
ERROR at line 1:
ORA-12913: Cannot create dictionary managed tablespace
SQL> create tablespace visionael_tempspace
2 extent management local
3 datafile 'c:\oracle\oradata\orak\orak_tmp01.dbf' size 10 M;
Tablespace created.
SQL> create tablespace visionael2_tempspace
2 datafile 'c:\oracle\oradata\orak\orak2_tmp01.dbf' size 10 M
3 ;
Tablespace created.
So twice the tablespaces have been created without using the rest of the options
I do not mean to use your help and cooperation to entirely solve my problems, but how do I proceed now?
-I don't know what's causing the error
-I have created two tablespaces whoich I either have to delete or incorporate within them the other options
-Alvi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2003 12:47 AM
тАО12-01-2003 12:47 AM
Re: editing .ora files
I am not sure, what problem you still have.
The first statement failed, because the default is a dictionary managed extent management, which conflicts with a locally managed system tablespace. In example two and three you used local extent management. The rest of the options was replaced by their default values. You can go on with the instructions, the software manual gives you.
greetings,
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2003 02:46 PM
тАО12-01-2003 02:46 PM
Re: editing .ora files
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS
------------------------------ ---------- -------------- ----------- -----------
MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
----------- ------------ ---------- --------- --------- --------- --- ----------
ALLOCATIO PLU SEGMEN
--------- --- ------
SYSTEM 8192 65536 1
2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL
SYSTEM NO MANUAL
As your reply above, you cannot create new DICTIONARY managed tablespaces, and you cannot migrate a LOCALLY managed SYSTEM tablespace back to DICTIONARY.
Syntax to create LOCALLY managed tablespace:
CREATE TABLESPACE userdata
DATAFILE '/u01/oradata/usr01.dbf' SIZE 500M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K;
Hope this can help you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-01-2003 03:03 PM
тАО12-01-2003 03:03 PM
Re: editing .ora files
extent_management_clause for Locally-managed tablespace:==
[ EXTENT MANAGENT
[ LOCAL
[ AUTOALLOCATE | UNIFORM [SIZE integer [K|M]]]]]
And UNIFORM specifies that the tablespace is managed with uniform extents of SIZE bytes. Default size is 1 megabyte.
Good luck.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2003 07:51 PM
тАО12-05-2003 07:51 PM
Re: editing .ora files
The products support team pointed me to an Oracle Repository Builder script, which eventually solved the problem.
I have though learnt a lot from your posts, and they might motivate me to learn more DBA stuff.
Thanks a lot
and Regards,
-Alvi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2003 09:13 PM
тАО12-05-2003 09:13 PM
Re: editing .ora files
learning DBA Stuff is a good idea. It will not only make your own work more fun and more satisfactory, when you know, what other people/documents are talking about but also you may give other people just the right hint to solve their own problem. ;-))))
So, learn and share,
Michael