RBS not using 2005-06-10 - By Paul Baumgartel
Yes, another example of terminology overloading!
Oracle often has to come up with new terms to describe concepts that
are similar to existing ones, or change those (such as snapshot ->
materialized view) that are confusing. My current favorite (related
to flashback query) is "decorate":
With the AS OF SQL clause, you can choose different snapshots for each
table in the query. Associating a snapshot with a table is known as
table decoration. If you do not decorate a table with a snapshot, then
a default snapshot is used for it. All tables without a specified
snapshot get the same default snapshot.
For example, suppose you want to write a query to find all the new
customer accounts created in the past hour. You could do set
operations on two instances of the same table decorated with different
AS OF clauses.
--=20
Paul Baumgartel
paul.baumgartel@(protected)
On 6/10/05, Jared Still <jkstill@(protected)> wrote:
> I recall that the first time I saw ORA-1555 (See ORA-1555.ora-code.com) I did not understand
> how things worked.
> My complaint to Oracle was that I was not using snapshots. :)
>=20
> The terminology in the error message is less than straightforward.
>=20
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>=20
>
--
http://www.freelists.org/webpage/oracle-l
|
|
