OraFAQ Forum: Server Administration » creating database(4 Merged)

Home » RDBMS Server » Server Administration » creating database(4 Merged) (10g, 10.1.0, xp2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

creating database(4 Merged) [message #515198]

Fri, 08 July 2011 09:39

abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india

Junior Member

how can i create a database if i have the list of tables, columns and constraints????

Report message to a moderator

Re: creating database [message #515199 is a reply to message #515198]

Fri, 08 July 2011 09:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>how can i create a database if i have the list of tables, columns and constraints????
issue CREATE DATABASE statement or utilize dbca utility

What exactly is XP2003?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: creating database(4 Merged) [message #515208 is a reply to message #515198]

Fri, 08 July 2011 10:00

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

In Oracle,
You create a database and then create a schema that will host your tables/indexes etc.
>>have list of tables and all columns and their constraints
If you mean the DDL of tables or create statements,
just put 'em in a .sql file and run it.
But first create the database, create users/schema etc.

Report message to a moderator

Re: creating database(4 Merged) [message #515229 is a reply to message #515208]

Fri, 08 July 2011 20:35

abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india

Junior Member

ok.
thanks for replying.

Report message to a moderator

Re: creating database(4 Merged) [message #515231 is a reply to message #515229]

Fri, 08 July 2011 20:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>how can i create a database if i have list of tables and all columns and their constraints????

post excerpt/sample of what you have.

Report message to a moderator

Re: creating database(4 Merged) [message #515339 is a reply to message #515231]

Sun, 10 July 2011 19:35

abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india

Junior Member

in a table named staff
columns type constraints
staff number int primary key
name varchar(20) not null
.
.
.
.
.
.
thus i have 10 tables like staff and i want to make database where i can enter and delete the rows in database.

i know how to create a database with dbca but problem is that i want to know the initial steps like
1. how tables are added to this database.
2.how can i access this database.
3. how an interface could be connect to this database etc.

Report message to a moderator

Re: creating database(4 Merged) [message #515340 is a reply to message #515339]

Sun, 10 July 2011 19:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>i know how to create a database with dbca but problem is that i want to know the initial steps like
>1. how tables are added to this database.
CREATE TABLE ...

>2.how can i access this database.
sqlplus

>3. how an interface could be connect to this database etc.
With much difficulty & likely beyond your capability

Consider installing & using APEX product from Oracle

Report message to a moderator

Re: creating database(4 Merged) [message #515487 is a reply to message #515340]

Mon, 11 July 2011 20:31

abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india

Junior Member

and if i have to submit it in compact disk in college then how can i make it portable????

Report message to a moderator

Re: creating database(4 Merged) [message #515490 is a reply to message #515487]

Mon, 11 July 2011 20:47

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>and if i have to submit it in compact disk in college then how can i make it portable????
To what does "it" refer?

research "TRANSPORTABLE TABLESPACE" which may or may not do what you desire

Report message to a moderator

Re: creating database(4 Merged) [message #515566 is a reply to message #515487]

Tue, 12 July 2011 04:15

cookiemonster
Messages: 13959
Registered: September 2008
Location: Rainy Manchester

Senior Member

abhisheksolankicse12 wrote on Tue, 12 July 2011 02:31

and if i have to submit it in compact disk in college then how can i make it portable????

What form do they want the DB in?
Probably they want a set of scripts that contain all the create commands.
Then again they may want an export of the DB.

If you don't know what they want then we can't really help you.

Report message to a moderator

Re: creating database(4 Merged) [message #515669 is a reply to message #515566]

Tue, 12 July 2011 19:40

abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india

Junior Member

they want me to run my database on their computer nothing more than that.
and i have the database named colg.
the problem is i don't know the step by step procedure to create the data files in database.
can you post video links to help me out for creating a small database of any company or shop or college?

Report message to a moderator