Oracle export and import utilities - Can we export a subset of a table? Explain
how posted by Babu
Kunwar
Can we export a subset of a table? Explain how
As per earlier version of Oracle subset of a table cannot be imported. But since
after its 8i version it was possible. We can do this as:
exp user_name/password tables=table_name query=\"where .......\" Further
explaining this query as exp mdcbs/oracle tables=s_acc query=\”where
acc_amt=100\”.
More links
What is a Collection?
Nested Tables vs. Associative Arrays
Nested Tables vs. Varrays
Explain the methods exist for collections. - EXISTS , COUNT , LIMIT , FIRST and
LAST , PRIOR and NEXT , EXTEND, TRIM , DELETE...............
|
