Table naming conventions

We are developing an Oracle database application for various clients. How can we be sure that the table names of our application will not conflict
with the table names of other applications which our clients may also have? For example, we have a table called "company" and another application has a table
called "company" and the client wants to run our application and the other application in the same Oracle database instance.

Options we've discovered so far include: 1) Run each application in its own database instance 2) Include a prefix on each table name to avoid common names; example instead

        of naming the table "company" name it "wr_company" 3) Fully qualify every reference to a table in selects/inserts etc by including the

        schema owner

What's the best way to handle this issue?

Thanks Received on Fri Aug 15 1997 - 00:00:00 CDT