Informix to Oracle question

Hi everybody:

I come from an Informix background where we log into a particular database instance by going to the directory, and typing 'isql' to get in. In Oracle, it seems that all the tables are kept in one central location and only seperated by users. This leads me to wonder what happens when you run out of space on that partition. Is there not a way to have seperate instances of databases? For example, can a marketing database be kept in a different directory from an accounting database, etc?

My other question concerns backup. In Informix, when someone screws up a table really bad, we just restore the files that make up that table. Does the same hold for Oracle?

Any help would be much appreciated. Received on Fri Nov 17 2000 - 00:33:07 CST