Could someone give me a basic outline of the appropriate creation of a database, tablespaces etc..
For example, say I want to create a new employee database. I install Oracle 8.1.7. I could use the installation to create a startup database. Should I? Do I always need to run the Catalog.sql, pubbld.sql? If I create a database from scratch are there other things I need to do to prepare that database for use? I've used Oracle enough to make some guesses at this point, but Ive always worked with existing databases and applications.
Once Oracle is installed do I create a user/owner for application. Say emp_owner. I give emp_owner enough rights to create tablespaces? I logon as emp_owner and create the tablespaces as that user so they belong to him? or create the tablespaces as system or sys and give emp_owner access? Then logon as emp_owner and start creating tables... etc...???
I can look up the technical details/references, I dont need someone to build a system for me, but could someone please give me a good "real world" outline of how its done the right way. The inter-relationship of the Oracle, the database, the datafiles, tablespaces, who owns what.. etc.etc.. not from so much of a technical level but more a planning level... an outline...
thanks for any input....
For example, say I want to create a new employee database. I install Oracle 8.1.7. I could use the installation to create a startup database. Should I? Do I always need to run the Catalog.sql, pubbld.sql? If I create a database from scratch are there other things I need to do to prepare that database for use? I've used Oracle enough to make some guesses at this point, but Ive always worked with existing databases and applications.
Once Oracle is installed do I create a user/owner for application. Say emp_owner. I give emp_owner enough rights to create tablespaces? I logon as emp_owner and create the tablespaces as that user so they belong to him? or create the tablespaces as system or sys and give emp_owner access? Then logon as emp_owner and start creating tables... etc...???
I can look up the technical details/references, I dont need someone to build a system for me, but could someone please give me a good "real world" outline of how its done the right way. The inter-relationship of the Oracle, the database, the datafiles, tablespaces, who owns what.. etc.etc.. not from so much of a technical level but more a planning level... an outline...
thanks for any input....