Database Reference
In-Depth Information
There is very useful SQL statement and I usually call it a tool
than just a SQL statement. This statement will give you the
output with all the tablespaces within the database along with all
the data files associated with each of these tablespaces.
SELECT a.TS#, a.Name, b.Name
FROM V$TABLESPACE a, V$DATAFILE b
WHERE a.TS# = b.TS#;
I call it a “tool” since with any other “tool” in real world you
need not to know how its designed and what were mathematical
formulae used to develop that tool e.g., with ranch all you need
to know how to use it and when to use it. That's it; unless you
want to open up your own Ranch design factory.
=
Figure 10-3: Both items on either side of equal (=) signs are tools with
each having a specific application in it's own domain.
Similarly, in software world all you need to know how to use the
application and not how it's being developed unless you want to
open up a software company or you're a programmer. In Oracle
world there are certain queries, I call as “Tools”. All you need to
know what information it provides and when to use it.
User-Managed Offline Backup
The other names given to this kind of backup are
Closed/Cold/Consistent Database backup. No recovery is needed
in this kind of backup during the restore process, as the SCN
(System Change Number) is consistent.
Search WWH ::
Custom Search