Exporting schemas from 8.1.7

[asb555]

Hi All,

I am trying to find a way to export the schemas for all of the users in my Oracle database in one shot. I don't, however , want to export the system or temp user schemas in this export. Is this possible? Any help would be appreciated.

Thanks in Advance,
Amir

 

[stefanhei]

Hi.
You could build your parameterfile with SQL*Plus.Connect as SYSTEM (or another privileged user) and spool to a file you wish to use as parameterfile.

select username||','
from dba_users
where username not in ('SYSTEM','SYS',...)

then edit the file: first line: owner=(
and replace the comma in the last line with )
and specify other parameters you need (filename,...)

Stefan