Home » RDBMS Server » Server Administration » creating database(4 Merged) (10g, 10.1.0, xp2003)
creating database(4 Merged) [message #515198] Fri, 08 July 2011 09:39 Go to next message
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????

Re: creating database [message #515199 is a reply to message #515198] Fri, 08 July 2011 09:41 Go to previous messageGo to next message
BlackSwan
Messages: 23059
Registered: January 2009
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/
Re: creating database(4 Merged) [message #515208 is a reply to message #515198] Fri, 08 July 2011 10:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
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.
Re: creating database(4 Merged) [message #515229 is a reply to message #515208] Fri, 08 July 2011 20:35 Go to previous messageGo to next message
abhisheksolankicse12
Messages: 22
Registered: June 2011
Location: india
Junior Member
ok.
thanks for replying.
Re: creating database(4 Merged) [message #515231 is a reply to message #515229] Fri, 08 July 2011 20:40 Go to previous messageGo to next message
BlackSwan
Messages: 23059
Registered: January 2009
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.
Re: creating database(4 Merged) [message #515339 is a reply to message #515231] Sun, 10 July 2011 19:35 Go to previous messageGo to next message
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.
Re: creating database(4 Merged) [message #515340 is a reply to message #515339] Sun, 10 July 2011 19:41 Go to previous messageGo to next message
BlackSwan
Messages: 23059
Registered: January 2009
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
Re: creating database(4 Merged) [message #515487 is a reply to message #515340] Mon, 11 July 2011 20:31 Go to previous messageGo to next message
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????
Re: creating database(4 Merged) [message #515490 is a reply to message #515487] Mon, 11 July 2011 20:47 Go to previous messageGo to next message
BlackSwan
Messages: 23059
Registered: January 2009
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
Re: creating database(4 Merged) [message #515566 is a reply to message #515487] Tue, 12 July 2011 04:15 Go to previous messageGo to next message
cookiemonster
Messages: 11202
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.
Re: creating database(4 Merged) [message #515669 is a reply to message #515566] Tue, 12 July 2011 19:40 Go to previous messageGo to next message
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?
Re: creating database(4 Merged) [message #515749 is a reply to message #515669] Wed, 13 July 2011 03:11 Go to previous messageGo to next message
cookiemonster
Messages: 11202
Registered: September 2008
Location: Rainy Manchester
Senior Member
Try searching on youtube
Re: creating database(4 Merged) [message #515752 is a reply to message #515669] Wed, 13 July 2011 03:15 Go to previous message
Michel Cadot
Messages: 59794
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/mv/msg/139482/490232/102589/#msg_490232

Regards
Michel
Previous Topic: how to set initial_rsrc_consumer_group
Next Topic: DBMS_JOB using sys account
Goto Forum:
  


Current Time: Wed Nov 26 17:45:15 CST 2014

Total time taken to generate the page: 0.09025 seconds