| DATABASE ARCHITECTURE FOR APPLICATION [message #315618] |
Tue, 22 April 2008 03:53  |
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
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
