Tablespaces, tables - could someone explain?

Hello,

normally we use interbase but one of our customer wants to use oracle as db for our application.

In interbase all jobs are quit simply - create the db, the tables, then the indices and start working.

But otacle seems to be a bit complexer. Perhaps someone can tell me more:

I run our db-create-table-script against oracle and all work fine under oracle 7.3.3 but under 7.3.4 I get some errors. The first error was that there was not enough room in the tablespace to create the table. I created a new tablespace tsp_a and create all tables in the tablespace tsp_a. When I commit the create-table-statements I got the error that I need a rollback-segment in the new tablespace.

I create it then and set it online and my script ran without errors.

Questions:
1.) What is a tablespace?
2.) What ist stored in a tablespace? The whole data or just the table-structure?
3.) If I have indexes and tables - is it better to create them in different tablespaces?
4.) the create tablespace takes several parameters about the size and the grow of the tablespace. How could I determine what size should I take for my data?
5.) What are rollback-segments?
6.) rollback segments can be public and private. What should I use under which circumstance?
7.) The tablespace is stored in a seperat file. What is stored in the ctl*, log* and sys*-file of an oracle-db?

Thanks

Stefan Westner Received on Sun Jun 07 1998 - 14:57:35 CDT