why it's not possible to create database in sql* plus?

Question

while creating database it says insufficient privileges .How select into command works in sql * plus? Used specially for back up tables.but how to copy data in other table?

Answer 1

insufficient privileges means permission not given to your id.

Ask your supervisor to give the privilege or send mail to concern person regarding this issue.



Till u get privilege , jus enjoy.........

Answer 2

sql> connect as sysdba

password : sys



should be able to create database, tablespaces etc :)

Answer 3

What user are you signed in as. Maybe that user doesn't have the rights.