How do you create our own schema? which privileges are required?

Questions by arvi.sardar

Showing Answers 1 - 2 of 2 Answers

JKreddy

  • Jan 24th, 2007
 

HI all.. To create/update schema one should have SYSADMIN privilages.. ie high level system admin privilages, And these privilages are also necessary for editing the DUAL table in the DB.. thx and regard's jk.m.reddy

  Was this answer useful?  Yes

Ajay Nerumati

  • Jan 29th, 2007
 

Hi All,A Schema in oracle is a logical representation of all the Oracle objects owned by a user.To make my explanation simpe , let me give an example.Let's say you own a bike, a computer, mobile. Now all these articles owned by you collectively is called a schema. Coming to oracle when a user is created by a superuser ( sysdba) , automatically a schema is created with the same name as the username. All object created by this user is called as the user's schema objetcs or simply schema.Thank you,Ajay Nerumati.Oracle DBA

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions