Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How many rows in a view
I don't think you have to worry about hitting a limit with the number of rows... The largest view I work with has 250 million of them on a 7.3.4 server :).
I'm not sure if there is a limit on the number of characters but should be able to comfortably put in a couple thousand chars at least.
-Peter
On Sat, 13 May 2000, Uni Mannheim wrote:
> Hello,
>
> if I wanted to create a view, which joins many tables, is there a limit on
> the number of rows the view returns?
> The view will have at least 70 rows.
> Or even worse, is there a limitation on the number of characters the select
> clause can contain.
> The Oracle version is 8.0.5 Enterprise
>
> thanks in advance
> christian
>
>
>
Received on Sun May 14 2000 - 00:00:00 CDT
![]() |
![]() |