Exclude specific tables from expdp

Here is the command

expdp user/password@sid schemas=schema_name include=TABLE:"IN ('TABLE1', 'TABLE2')" 

directory=DATAPUMP_DIR dumpfile=user_date.dmp logfile=user_date.log

Some operating systems need special characters to be escaped

include=TABLE:\"IN (\'TABLE1\', \'TABLE2\')"

Or

include=TABLE:\"IN \(\'TABLE1\', \'TABLE2\'\)"
  

Update a table column using a sequence

create table duplicate as select * from original
alter table duplicate add ID number;
create sequence seq1

set pagesize 0

set linesize 200

spool update.sql
select 'update duplicate set ID='||seq1.nextval||q'[ where rowid=']'||rowid||q'[';]' from duplicate;

spool off

>@update.sql