Oracle export and import utilities - Can we monitor how fast a table is
imported? How? posted by
Babu Kunwar
Can we monitor how fast a table is imported? How?
Yes we can view the rate at which table is being imported inside a database. We
can do this by using FEEDBACK keyword. Feedback command tells IMP to display
the values after each row import. The default value is zero so, no feedback
will be provided unless you provide a value to it.
Syntax: show feedback FEEDBACK ON for 1 or more rows.
More links
Explain subqueries with an example - A subquery is a query within a query. The
inner query is processed first. They are most commonly used to return data from
multiple tables when the exact value is not known................
|
