hi!
easiest wasy migth be to just run an SQL script after the import.
You can do this in a batch script or cron process very easily.
i.e.
imp blah/blah@sever file=c:\mydump.dmp full=y
sqlplus blah/blah@server @c:\extrasql.sql
Otherwise why not make an updated export file that contains the changed columns and trigger code.
>I have built a table by doing a SQL-Select from two other tables. Once I have this table, I added columns for deletion status, user, update time stamp, and unique row id. Then I added code to add info to these new columns when a row is inserted/modified.
>
>However, these 4 new columns are blank. How do I import the table and get those columns populated at the same time?
>
>Thanks.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only