0

How to create database in oracle.
Is the tablespace and database same?
Do we need to install client from oracle 9i?

I have the code as follows

Create Tablespace SCT_DATA
Datafile 'sct_data.dat' size 10M
online;

and i come across the error as follows
Create Tablespace SCT_DATA
*
ERROR at line 1:
ORA-01031: insufficient privileges

What should i do?

5
Contributors
4
Replies
5
Views
7 Years
Discussion Span
Last Post by sudhanshoo
0

Hi

A tablespace is contained within the database. It is the way oracle sees a file at the O/S level.

If you are using 9i connect to the dataabse from the command prompt

C:\> sqlplus "/ as sysdba"

SQL>

Then create your tablespace

create tablespace my_data datafile
'c:\oradata\orcl\my_data01.dbf' size 512m
autoextend on next 128m maxsize 4096m
extent management local autoallocate;

Hope it helps.

Alistair

0

The error message is self explanatory.

You need to try using the command from sys or system log in or from any other account having the required prevelages.

0

You need to be logged as sysdba only then you'll have sufficient previledges to create a desired tablespace...

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.