Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.
Course Of The Month
2 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Oracle database exports and imports question
Posted on 2013-01-08
I need to learn how to do database exports and imports at user level and full ones.
Can someone guide me through the process?
I also need to learn how to clone a database using expdp/impdp
Can someone guide me through the process?
I also need to learn how to clone a database using expdp/impdp
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
5
10 Comments
Active 5 days ago
Good article here on this:
http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php
Cloning a database via export/import can be easy or hard depending on a few factors.
Does your clone database already exist?
Are there a lot of foreign key constraints (had problems in the past with this, haven't tried recently to see if it's better)
Personally, I've found it to be much faster to do a restore from backup when cloning a database. Not only does it get the job done (usually faster unless it's a very small database), you also get to test your backups while you're at it.
http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php
Cloning a database via export/import can be easy or hard depending on a few factors.
Does your clone database already exist?
Are there a lot of foreign key constraints (had problems in the past with this, haven't tried recently to see if it's better)
Personally, I've found it to be much faster to do a restore from backup when cloning a database. Not only does it get the job done (usually faster unless it's a very small database), you also get to test your backups while you're at it.
Active 5 days ago
OK then for ease of use:
Create another empty database much like your first one (users, tablespaces etc).
Export as per the article above from the first database.
Import as per the article above into the second database.
If you want to do it more than once, you will need to take action to decide what to do with any existing tables. Check the TABLE_EXISTS_ACTION option in the parameters for impdp.
Create another empty database much like your first one (users, tablespaces etc).
Export as per the article above from the first database.
Import as per the article above into the second database.
If you want to do it more than once, you will need to take action to decide what to do with any existing tables. Check the TABLE_EXISTS_ACTION option in the parameters for impdp.
I just tried to run full export on my db and got permissions errors. What permissions does a user need to run a full database export?
Active 5 days ago
See: http://docs.oracle.com/cd/E11882_01/server.112/e22490/original_export.htm#SUTIL2641
"To export tables owned by another user, you must have the EXP_FULL_DATABASE role enabled. This role is granted to all database administrators (DBAs).
If you do not have the system privileges contained in the EXP_FULL_DATABASE role, then you cannot export objects contained in another user's schema. For example, you cannot export a table in another user's schema, even if you created a synonym for it."
"To export tables owned by another user, you must have the EXP_FULL_DATABASE role enabled. This role is granted to all database administrators (DBAs).
If you do not have the system privileges contained in the EXP_FULL_DATABASE role, then you cannot export objects contained in another user's schema. For example, you cannot export a table in another user's schema, even if you created a synonym for it."
Active 5 days ago
Guess that depends if you have DBA access or not.
If you're not the DBA, you can only export objects owned by you.
If you have DBA access (or the EXP_FULL_DATABASE privilege) on the user you connect to the database as, then you can.
Do you have an account you can run expdp as that has the required privs?
If you're not the DBA, you can only export objects owned by you.
If you have DBA access (or the EXP_FULL_DATABASE privilege) on the user you connect to the database as, then you can.
Do you have an account you can run expdp as that has the required privs?
Active 5 days ago
I see you've opened a new question on this topic, hadn't had a chance to respond to this yet, will let that part of the question be answered in the new topic.
As mentioned above (and in the replies to the new question) an import isn't a "clone" - you need to have an existing database to import into.
As mentioned above (and in the replies to the new question) an import isn't a "clone" - you need to have an existing database to import into.
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Attention: This article will no longer be maintained. If you have any questions, please feel free to mail me. jgh@FreeBSD.org
Please see http://www.freebsd.org/doc/en_US.ISO8859-1/articles/freebsd-update-server/ for the updated article. It is avail…
Configuring and using Oracle Database Gateway for ODBC
Introduction
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
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
Course of the Month2 days, 9 hours left to enroll
718 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.