export schema

thomasliju
thomasliju used Ask the Experts™
on
how we export schema with out using the schema password...
what is syntax
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Database Administrator
Commented:
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

Author

Commented:
schemas options is helpful.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial