Home » RDBMS Server » Server Administration » create new database
create new database [message #410525] Sun, 28 June 2009 00:54 Go to next message
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 #410526 is a reply to message #410525] Sun, 28 June 2009 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts
Administrator's Guide

Regards
Michel
Re: create new database [message #410548 is a reply to message #410525] Sun, 28 June 2009 09:21 Go to previous messageGo to next message
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..
Re: create new database [message #410565 is a reply to message #410548] Mon, 29 June 2009 00:22 Go to previous message
imuharram
Messages: 48
Registered: January 2009
Member
Thank you very much
Previous Topic: oracle database migration
Next Topic: error setting arcive log distenations
Goto Forum:
  


Current Time: Wed Dec 07 12:59:53 CST 2016

Total time taken to generate the page: 0.11565 seconds