Reverse Engineering

Hello,

2 questions...

[1]

Is there an easy and effect way to reverse engineer the schema definition of an already defined database instance? (ie. generate a script containing table, tablespace, index and constraint definitions?).

[2]

We have a table detailing essential (minimal) user information such as name, login and password, and a further (large) table detailing additional information such as user interests and preferences. Since there is a strict one to one relationship between these tables, I would like to add additional fields to out preliminary table and scrap the additional user information. However, does this mean that the efficiency of selecting from table joins will suffer due to having an enormous user table or does ORACLE optimize this itself?

Any help would be appreciated!! Received on Mon Mar 24 1997 - 00:00:00 CST