Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RBS not using

Re: RBS not using

From: Paul Baumgartel <paul.baumgartel_at_gmail.com>
Date: Fri, 10 Jun 2005 12:45:41 -0400
Message-ID: <f8c477105061009457f38bbb@mail.gmail.com>


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_at_aya.yale.edu

On 6/10/05, Jared Still <jkstill_at_gmail.com> wrote:
> I recall that the first time I saw ORA-1555 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
Received on Fri Jun 10 2005 - 12:50:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US