By default, I'm pretty sure its table level.
eg in one session I did this:
drop table scott.a purge;
drop table scott.z purge;
create table scott.a ( x timestamp );
create table scott.b ( x timestamp );
declare
ts timestamp;
begin
loop
ts := systimestamp;
insert into scott.a values (ts);
insert into scott.b values (ts);
commit;
end loop;
end;
/
and then datapump looked like this:
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
. . exported "SCOTT"."A" 12.15 MB 796555 rows
. . exported "SCOTT"."B" 12.50 MB 819595 rows
. . exported "SCOTT"."ABC" 5.898 KB 1 rows
. . exported "SCOTT"."DEPT" 6.031 KB 4 rows
. . exported "SCOTT"."EMP" 8.781 KB 14 rows
. . exported "SCOTT"."SALGRADE" 5.960 KB 5 rows
. . exported "SCOTT"."T" 5.054 KB 1 rows
. . exported "SCOTT"."BONUS" 0 KB 0 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
You can use CONSISTENT=Y (a legacy mode param) or FLASHBACK_TIME to override this.