Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How do I export a Schema within a database

Posted on 2007-11-29
1
Medium Priority
?
3,493 Views
Last Modified: 2013-12-18
I  need to export a schema with all their objects. What command would I issue to do this?
0
Comment
Question by:sikyala
1 Comment
 
LVL 18

Accepted Solution

by:
rbrooker earned 2000 total points
ID: 20377945
exp userid=<name>/<pdw>@<db> owner=<schema_to_export> log=<log_file>

or you can put them into a parfile

-- START --
userid=user/pwd@db
logfile=/log/file.log
owner=(<schema_to_export>)
grants=Y
rows=Y
constraints=Y
<whatever other options you want to include>
-- END --

then

exp parfile=<name_of_created_parfile>

this will then use the options you specified and export what you want...

good luck :)
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question