Home » RDBMS Server » Backup & Recovery » DATABASE ARCHITECTURE FOR APPLICATION (oracle 9, forms6i, windows-xp)
DATABASE ARCHITECTURE FOR APPLICATION [message #315618] Tue, 22 April 2008 03:53 Go to next message
supriya_546
Messages: 56
Registered: October 2005
Location: hyderabad
Member
Hi Tom,

I am developing a small application for maintaining student information using forms6i,oracle9 and
os-windows.
i have sample version of oracle software which is downloaded from oracle site (right now using the
same).
here my question is ...

1) can i use sample version of database for real application?
2)is it creates any problem after sometime?

right now i have created one new user (admin) by connecting to system user and started creating
tables,...etc

3) I am not much familiar with concepts of maintainance of database...i mean

how to maintain table-spaces/extents once it's full
how to extent the extents/segments/tablespaces
any auto extent feature? if yes, where to set this parameter?

the people who are going to use this application doesn't have any DBA person.

what are the steps need to take to handle databse without DBA?

Transaction related info : daily nearly 5000 to 6000 transactions in atable having around 10
columns in a table.
column max size is varchar2(<30)...

application has hardly 15 to 20 tables.

appreciate quick response.


Thanks in advance,
Supriya


Re: DATABASE ARCHITECTURE FOR APPLICATION [message #315623 is a reply to message #315618] Tue, 22 April 2008 04:08 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Who is Tom?

Go to tahiti.oracle.com and read Concepts Manual.
Re: DATABASE ARCHITECTURE FOR APPLICATION [message #315624 is a reply to message #315618] Tue, 22 April 2008 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) There is no sample version of Oracle, all versions is production ones.
Sample database is made for training but it will work with any small application. You can easily create your own with dbca.

2) See 1)

3) Read 2 Day DBA and Administrator's Guide

4) Why is this posted in "backup and recovery" forum? If you want accurate answer, post in appropriate forum.

Regards
Michel
Re: DATABASE ARCHITECTURE FOR APPLICATION [message #315625 is a reply to message #315623] Tue, 22 April 2008 04:15 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ah ha! I didn't see the Tom.
It is just a copy and paste of his question on AskTom:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2168279457908#793854000346880243

We will see what Tom will answer.

Regards
Michel
Previous Topic: Backup of Archive log files
Next Topic: Backup problem in Oracle XE
Goto Forum:
  


Current Time: Sun Dec 11 04:18:00 CST 2016

Total time taken to generate the page: 0.06288 seconds