|
|
|
|
Re: Need help to create tablespace for administration [message #484369 is a reply to message #484367] |
Tue, 30 November 2010 01:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I don't know what you mean by "admin usage", but there are some standards that apply to all tablespaces: you should create it as locally managed with automatic segment space management. Do you understand why?
My preference is to use a uniform extent size, but some DBAs disagree: they say system managed extent sizes are preferable. If you intend to use one tablesapce for all your objects, then system managed extent size might be a better option. Think about it.
As for the size of the datafile(s), you will have to make your own estimates based on the expected size and numbers of the rows, not forgetting the indexes. There is a segment space advisor that will help you to do this.
I hope this gives you a few hints that will help you to direct your reading in the documentation.
|
|
|
|
|
Re: Need help to create tablespace for administration [message #484418 is a reply to message #484415] |
Tue, 30 November 2010 07:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
To give a size estimate we'ed need to know what you are auditing and what you mean by security (and user accounts - are these oracle accounts or something different?). Could be you need 500M, could be you need 500G or 500T. We have no way of knowing with the information provided.
|
|
|
|
Re: Need help to create tablespace for administration [message #484425 is a reply to message #484419] |
Tue, 30 November 2010 08:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Dear fearroi, you totally misrepresented your problem! This is nothing to do with the schema description you supplied, or with space management.
The topics you need to research are database auditing, implemented with the AUDIT command; resource and session management, implemented with CREATE PROFILE; system privileges, assigned with GRANT and CREATE ROLE; and space quotas, set with ALTER USER.
That should give you enough to get started
|
|
|
|
|
Re: Need help to create tablespace for administration [message #484578 is a reply to message #484462] |
Wed, 01 December 2010 12:37 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Hello again - it is time you did some work.
Try to create a tablespace. You have the advice on what options to use, so read up on the CREATE TABLESPACE command and have a go. That deals with your (A).
Then create a schema. You have the advice on that too, which should fall into place when you read up the CREATE USER command. That should sort out (B).
Then create your tables, (C).
Any problems: post the SQL you ran, with the errors, according to the Posting Guidelines.
Over to you!
|
|
|