| create new database [message #410525] |
Sun, 28 June 2009 00:54  |
imuharram
Messages: 48
Registered: January 2009
|
Member |
|
|
This is the first time I implement an oracle application, and I need help.
Oracle 10g database has been installed in Windows 2003 server. I have System user and password. Now I want to create my tables, I usually create a new user and connect through that user and have my tables created there. And in the forms I connect through the new username and password.
But I got confused when I found something called tablespace while surfing the internet, and I'm not sure what to do now.
Should I create a new user from the System user, and continue working from the new user, or should I create a new tablespace and how do I do that?
I'm sorry, but I'm new to this
|
|
|
|
|
|
| Re: create new database [message #410548 is a reply to message #410525] |
Sun, 28 June 2009 09:21  |
selvakumarmvs
Messages: 12
Registered: February 2009
|
Junior Member |
|
|
login into sys as sysdba user
1. create tablespace ......(refer guide)
2.create user user_name idetified by password default tablespace
tablespace_name
3.grant connect,resource to user_name
then login into your user
create table....
note: you can create user without default tablespace option...it will take and store data in default system tablespace..it is not recommended
Regards
selva..
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
