Re: saving an entire schema to disk

>> i have been asked to figure out a way to
>> save an entire schema that we have residing on an oracle server to
>> cd/disk.

Oracle version is always useful.

Anyway, you need to read up on Oracle export "exp" utility. To export a specific schema, the syntax will be something like:

exp system/<system_password> file=<dumpfile_name> log=<logfile_name> owner=<schema_name>

HTH -g Received on Wed Jan 11 2006 - 08:44:02 CST