|
-
My correction with Mr.
adewri is
The commands also can be generated by..
export the database with nodata. -->use rows=n
import the dump file with ignore=n(WHich is default)..
the failed commands will be logged into the
log file that you are specifying. (log=....)
Regarding the insert command .. generating..
You have to write a procedure..
step 1:Cursor selects the tables of that schema
Loop starting
Step 2:Cursor selects the number of columns in the table.
Loop
step 2: For The number of columns generate the required
columns selection command .
step 3: accumulate the selection columns into a variable.
Need to add '' if the field is of type char
step 4: add to the insert into command with that table name
Use Dba_tab_columns to find the column list of a table
regards
giri
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|