Results 1 to 6 of 6

Thread: Insufficient privileges error during tablespace creation

  1. #1
    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.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,949

    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.

  3. #3
    Join Date
    May 2008
    Posts
    2,015

    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.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,010

    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;

  5. #5
    Join Date
    May 2008
    Posts
    2,302

    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 06:18 PM.

  6. #6
    Join Date
    Oct 2005
    Posts
    2,394

    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');

Similar Threads

  1. Replies: 1
    Last Post: 25-10-2012, 04:40 PM
  2. Insufficient Privileges as an Administrator in Windows 7
    By Wamika in forum Operating Systems
    Replies: 4
    Last Post: 30-12-2010, 10:41 PM
  3. Insufficient Privileges Error while Copy and Pasting Files
    By Dewei in forum Hardware Peripherals
    Replies: 6
    Last Post: 30-05-2010, 06:26 AM
  4. Creation of tablespace in oracle database
    By Garlands in forum Software Development
    Replies: 3
    Last Post: 05-02-2010, 09:58 PM
  5. Error message: insufficient privileges to modify this file
    By Philly lawyer in forum Vista Help
    Replies: 5
    Last Post: 04-10-2007, 01:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •