Re: Number of files in an Instance?

S. Snadow wrote:
>
> Is there a limit to the number of files that can be in an Oracle 7.3
> instance?
>

Yes, there is a parameter 'db_files' that can be set in the init.ora parameter file. Check the Oracle 7 Administrators Guide Page A-15 if you need more information on its use.

> Can you do union in view across instances and gain the optimizer
> advantages?
>

 I am not sure.....
> Thanks for any responses!
>
> Sarah Snadow

-- 
+-------------------------------------+-----------------------------------+
| Wayne Taylor, Developer             |Human Beings, who are almost
 unique|
| Electrical & Fuel Handling Division |in having the ability to learn
 from|
| Ford Motor Company                  |the experience of others, are
 also |
| wtaylor1_at_ford.com                   |remarkable for their
 apparant      |
| ataylor_at_rust.net                    |disinclination to do
 so.           | 
|                                     | - Douglas
Adams                   |
+-------------------------------------+-----------------------------------+