Create new database

[evergreean]

I now connected to Oracle 9i with my username and password:
sqlplus jones/mypassword@//abcd123e/kcl

I created tables for my database but now what if I want to create another database? Do I use the same username and password and then how do I create a different database??
Or do I get a new Schema/username for my new database?

 

[slaing]

Hi,

To create another schema / table owner within your kcl instance :

log on to sqlplus as SYS (I guess you must have done that in order to create 'jones'), and enter 2 commands :

SQL> grant connect,resource to smith identified by smithpassword;
SQL> alter user smith default tablespace mytablespace quota unlimited on mytablespace;

where mytablespace is the tablespace that you want smith to use.

You can do the same thing with a few clicks in Oracle Enterprise Manager if you prefer.

I think that will achieve what you want,m but if you're actually wanting to create a completely new instance (such as kcl_test) then you need to run the DB Creation Assistant again.


Steve

 

[LKBrwnDBA]

The term 'database' is many times misused (in confusion) to reference any of the following:

Instance - set of DBMS programs executing under an OS
Database - Physical database, set of files managed by an
instance and comprising the collection of
Schemas
Schema - Logical construct, set of objects used by the
application(s)

So, what is it you wish to create, another what?


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[evergreean]

Oracle really is different than my Access and MySQL experience.

I now will rephrase my question (and title of this post if I could) to say "Create new Schema"
Since my first schema was created with my lastname now I know in future to create my next schema with the name of what I want to call the second "Logical construct, set of objects used by the application(s)" or known as schema?
If my next database creation/assignment is going to be tracking "Projects" then the schema/username will be created as Projects. I will then login using Projects username. Is that usually how you name your Schema/username?
It will then look like this with the instance (called kcl) staying the same on all my connection statements but the username changing to projects because that is what my new Schema is called?
sqlplus projects/myProjectsPassword@//abcd123e/kcl

 

[Turkbear]

Hi,
You do not need to use the schema name as the login after the schema is created/populated..as the schema owner you grant rights to other users ( preferably through Roles)..
Read the Oracle concepts and DBA manuals and forget almost everything you learned using Access ( and to a lesser extent, MySql)..Oracle is quite a different animal and requires effort to use effectively..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[evergreean]

Thanks for all the info.