One problem with constraints missing in source and target database....

Advertisement
DB Gurus,
In my database I am going to export and import data using datapump but dont specify CONTENT clause.
so when I start working on my application, I came to know there are some constraints are missing. now how to check what are the constraints are missing from Source database and how to create those missing constraints on Target database?
Suggest me if you have any idea.
Advertisement

Replay

Create a database link between source and target schema.
Use all_/dba_/_user_constraints to generate the difference using MINUS operator.
something like this:
select owner,constraint_name,constraint_type from [email protected]
MINUS
select owner,constraint_name,constraint_type from dba_constraints

Problem with Crystal reports for Eclipse and Postgres-databases

Hi, Is there a known problem when using a PostgreSQL-database to create a report with Crystal reports Plugin? When I drag a table, then occurs a error-windows, that the object can't  created. I have found a workaround for solving the problem. After n

Problem with Xsan 2.1.1 and Mac Os server 10.5.6

Hi, We have a big problem with xsan 2.1.1 and Mac Os server 10.5.6. - We have one server, is a Open Directory Master, and also is a metadata controller of xsan2. The Volumes of xsan2 are shares via afp, and the clients (moreless 50) connect with serv

Performance Problems with MS IE 6.0 and EP 7.0 (2004s)

Hello, we have a problem with ie 6.0 webbrowser and EP 7.0 (2004s). When we open for example the theme editor in the ep-system-administration site we must wait with MS ie 6.0 webbrowser ~ 18s for the site opening. With firefox 2.0 we can open the the

I HAVE PROBLEMS WITH LION 10.7.1 AND THE PRINTER EPSON STYLUS TX515FN, DOES SOMEBODY KNOW IF IT IS POSSIBLE TO BE USED?

I HAVE PROBLEMS WITH LION 10.7.1 AND THE PRINTER EPSON STYLUS TX515FN, DOES SOMEBODY KNOW IF IT IS POSSIBLE TO BE USED?Yes it is, you must install the driver. Download the driver from here here: http://www.latin.epson.com/v4/asp/soporteDrivers.asp?id

I have problem with Itunes losing where podcasts and some purchased music is located. Don't know how Itunes losing the locations of the files and I can't find the files on my hard drive. What can I do to stop Itunes losing location and restore my files?

I have problem with Itunes losing where podcasts and some purchased music is located. Don't know how Itunes losing the locations of the files and I can't find the files on my hard drive. What can I do to stop Itunes losing location and restore my fil

Help solve the problem, with the lifting of purchasing and payment card is locked, and now I can not pay for her purchases in the app store

help solve the problem, with the lifting of purchasing and payment card is locked, and now I can not pay for her purchases in the app storeContact the App store for Apple ID help. Their support link is on the right of the App store window LNRead othe

I'm using mac with the newest operating system (snow leopard 10.6.7). since I've updated to Firefox 4 It doesn't display Hebrew fonts- I didn't have any problems with it before the upgrade and in safari I don't have this problem.

Hello, I'm using Mac with the newest operating system (snow leopard 10.6.7). since I've updated to Firefox 4 It doesn't display Hebrew fonts- I didn't have any problems with it before the upgrade and in safari I have no problem with it. please help m

Updated Illustrator CC to CC 2014, having problems with CC performance. Slow and does not quit

Updated Illustrator CC to CC 2014, having problems with CC performance. Slow and does not quit. What can be causing the issue?Hello, please checkout my post concerning lagging issues. I've also provided a link to a video I've recorded showing the Ill

My host name changes every few days, since Xmas adding a macbook its changed 6 times. Do I need to stop this? Does it cause problems with sharing between the iMac and macbook?

my host name changes every few days, since Xmas adding a macbook its changed 6 times. Do I need to stop this? Does it cause problems with sharing between the iMac and macbook?There are several possible causes for this problem. 1. Two (or more) comput

Is anyone having problems with the battery drains quickly and the iphone4 heats up in use and in charging after upgrading to 5.1.1?

Is anyone having problems with the battery drains quickly and the iphone4 heats up in use and in charging after upgrading to 5.1.1?I have had the same problem but I seem to be getting somewhere to fixing it!!! My battery was going down at 20% an an h

Problems with X-Fi Xtreme Music and

Hi people. I have been having some problems with enableing EAX in ganes and so on. Fot instance in Warcraft 3 Frozen Throne, it says something like this "The 3D provider could not be installed, reverted to next best provider". EAX in that game i

I still have a warranty but it will be out in a week. i previously have a sound distortion problem with my mac for months and suddenly it just fix itself. what should i do? i'm worried that it will comeback and i dont have a warranty anymore.

i still have a warranty but it will be out in a week. i previously have a sound distortion problem with my mac for months and suddenly it just fix itself. what should i do? i'm worried that it will comeback and i dont have a warranty anymore.JoBautis

R3AC1- Object Bus_Trans_Msg source and target sites missing

Hi, In the Txn code: R3AC1 for the object Bus_Trans_Msg we need to enter the source- CRM and target site-R/3 under the tab Initial flow settings which is not editable. when we do initial download of this object in txn:R3AS if throws an error. Please

Keeping table name same in source and target

is it possible to keep the table name the same in source and target (they're on sepearte databases). Seems like OWB wants to rename the output table (usually adds 1 on the end). When I tried to rename I got a message saying that table name exists.In

Error saving map. Stored procedure returned non-zero result. Check if source and target schemas are present.

I am using VS 2012 and BizTalk 2013 and attempting to deploy an application to BizTalk when I get these errors: Error 47 at Microsoft.BizTalk.Deployment.Assembly.BtsMap.Save()    at Microsoft.BizTalk.Deployment.Assembly.BtsArtifactCollection.Save()

Problems with some songs in iTunes (and my iPod)

Hi, I do not know whether this is the right category for my problem, but I did not find a suitable one. I have problems with some songs in iTunes. They do not sound right. It is hard to me to describe my problem in English (thanks to apple's "great&q

Facebook App - Problems with Newsfeed & Missing Notifications/Messages

SOMEONE PLEASE HELP. I continue to have two frustrating problems with my Facebook for Blackberry app that I installed directly via RIM's website: 1. I am always missing notifications & messages on my blackberry. Sometimes they come through and other

Problem with Oracle Processes - ora_cjq0_ SID and ora_qmnc_ SID

Hello, We are having problem with few Oracle Processes which are failing by themselves and also cosuming high CPU load. Few of the Processes are : ora_cjq0_<SID> ora_qmnc_<SID> I did not find any relevant SAP Note about the above two Processes

Problem with 10.3.181.14 and FF browser problems

I just installed 10.3.181.14 and I immediatedly encountered a problem with FF 3.6.17 cache. When I run CCleaner I never had a problem until now. It keeps saying the FF is still open and it's not. When I figured it out that it had something to do with