Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Insufficient privileges error during tablespace creation

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 13-02-2010
Member
 
Join Date: Nov 2009
Posts: 56
Insufficient privileges error during tablespace creation
  

Hello

I am unable to execute a query due to some privileges error.When I issue the below command the database occurs "insufficient privileges" and statement is given below:

CREATE TABLESPACE Org_emp DATAFILE 'Emp_file.dbf' SIZE 100M
BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K SEGMENT SPACE MANAGEMENT AUTO ONLINE


Why it is generating such type of error,what are the privileges is required to create a tablespace.

Reply With Quote
  #2  
Old 13-02-2010
Member
 
Join Date: Apr 2008
Posts: 1,948
Insufficient privileges error during tablespace creation

Insufficient privileges error during tablespace creation :

You can create the tablespace,if you have a sufficient privileges.You can't create tablespace without the "CREATE TABLESPACE" privilege which is granted by owner of the database means Database administrator.

If you are running as a database administrator then you not need to receive this privilege.As a owner of database you can create tablespace and drop the running tablespace also.
Reply With Quote
  #3  
Old 13-02-2010
Member
 
Join Date: May 2008
Posts: 2,007
Create tablespace privilege in oracle

Create tablespace privilege :

The create tablespace privilege is a system privilege. According to the type of privileges :Object and system privilege .

This(Create tablespace) privilege is used by the administrator or administrator suggested user.According to the behavior of the system, if DBA has granted any privilege with admin option then the granted privilege can grant this privilege to another user of the database. In the case,if DBA revokes the privilege from the granted user then the other user which is granted through the second user can still run with this privilege.
Reply With Quote
  #4  
Old 13-02-2010
Member
 
Join Date: Apr 2008
Posts: 2,000
Creating tablespace in database

Creating tablespace in database :

To create the database tablespace,you must have sufficient privilege because you are going to make another space for the database users or for object storage.

To create the tabelspace,execute the below command and decide the space of tablespace according to use :

Code:
create tablespace Tabs
  logging
  datafile '/dbf1/tbsfile.dbf' 
  size 50M 
  autoextend on 
  next 32m maxsize 2048m
  extent management local;
Reply With Quote
  #5  
Old 13-02-2010
Member
 
Join Date: May 2008
Posts: 2,291
Dictionary managed tablespace in database

Dictionary managed tablespace :

The dictionary managed is used to keep track free or used data blocks.When an extent is allocated or freed for reuse then this free space information is recorded in the SYS.FET$ table.

Converting a tablespace from Dictionary to Local :

SQL> exec dbms_space_admin.Tablespace_Migrate_TO_Local('tabs1');
You can convert the dictionary managed tablespace into locally managed tablespace.

Last edited by Zecho : 13-02-2010 at 07:18 PM.
Reply With Quote
  #6  
Old 13-02-2010
Member
 
Join Date: Oct 2005
Posts: 2,389
Locally Managed Tablespace in database

Locally Managed Tablespace in database :

The locally managed tablespace which manages its own extents maintains a bitmap to record the free and used space data blocks.Whenever a data block is freed to use then this space is allocated to another object of database.To create the Locally managed tablespace,change the value of EXTENT MANAGEMENT with LOCAL.

If you need to convert a locally managed tablespace into data dictionary tablespace execute the following procedure.

Code:
SQL> exec dbms_space_admin.Tablespace_Migrate_FROM_Local('tabs2');
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Insufficient privileges error during tablespace creation"
Thread Thread Starter Forum Replies Last Post
1321 The Installer has insufficient privileges to modify this file HudSon Windows Security 1 25-10-2012 05:40 PM
Insufficient Privileges as an Administrator in Windows 7 Wamika Operating Systems 4 30-12-2010 11:41 PM
Insufficient Privileges Error while Copy and Pasting Files Dewei Hardware Peripherals 6 30-05-2010 07:26 AM
Creation of tablespace in oracle database Garlands Software Development 3 05-02-2010 10:58 PM
Error message: insufficient privileges to modify this file Philly lawyer Vista Help 5 04-10-2007 02:20 AM


All times are GMT +5.5. The time now is 09:42 PM.