Hello,
I have problem to export statspack schema. I am using expdp utility but no data are exported. But when i create new table it's exported only this new table.
Creat table stats$test as
select * from stats$snapshot;
I have tried multiple variations of the expdp command:
expdp perfstat/perfstat@server DUMPFILE=PERFSTAT_TEST6.dmp LOGFILE=PERFSTAT_TEST6.log DIRECTORY=dumps parfile=spuexp.par
expdp system/pass@server DUMPFILE=PERFSTAT_TEST5.dmp LOGFILE=PERFSTAT_TEST5.log SCHEMAS=PERFSTAT CONTENT=ALL DIRECTORY=dumps parfile=spuexp.par
expdp system/pass@server DUMPFILE=PERFSTAT_TEST4.dmp LOGFILE=PERFSTAT_TEST4.log SCHEMAS=PERFSTAT DIRECTORY=dumps
etc.
I also tried sys user. but only stats$test is exported.
Thanks.