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

x
?
Solved

export schema

Posted on 2014-02-27
2
Medium Priority
?
339 Views
Last Modified: 2014-10-15
how we export schema with out using the schema password...
what is syntax
0
Comment
Question by:thomasliju
2 Comments
 
LVL 23

Accepted Solution

by:
Steve Wales earned 2000 total points
ID: 39892478
If using exp, you can do that by using the SYSTEM username and password to authenticate to the DB and then specify owner=user1,user2 etc

If using expdp, use the schemas= keyword

Review the documentation for list of full options to exp and expdp:

The Utilities Guide has the documentation for both: http://docs.oracle.com/cd/E11882_01/server.112/e22490/toc.htm
0
 

Author Closing Comment

by:thomasliju
ID: 40383618
schemas options is helpful.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to take different types of Oracle backups using RMAN.

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