- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- user constraints export / import
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-22-2006 07:50 PM
тАО11-22-2006 07:50 PM
I'm exporting an ORACLE 8.1.7 database through the exp command: parameters are:
OWNER=
snml
USERID=snml/snml@rm745_1_ded
FILE=/alcatel/MigrDataRepository/ORACLE/db_export.dmp
I see that some constraints, namely user constraints of NOT NULL, are not present in the imported database...
Before the import I drop any tablespace on the target database then I run the import ... after that I see that no such constraints are present.
Why?????
Thanks for your support
Enrico
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-22-2006 08:13 PM
тАО11-22-2006 08:13 PM
SolutionThe default settings for CONSTRAINTS for both exp and imp is 'Y'
Unless you have explicitly mentioned the contrary, the check constraints should be there!
can you please re-check your script.
you may also query the dictionary view user_constraints for the names and the count.
Also, verify the export and import logs.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-22-2006 08:13 PM
тАО11-22-2006 08:13 PM
Re: user constraints export / import
Try it with CONSTRAINTS=y
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-22-2006 08:17 PM
тАО11-22-2006 08:17 PM
Re: user constraints export / import
if you just use the exp command it will guide you through the process.
What sort of constraints are you referring to?
Not null constraints are on columns on tables, not users ! Users have grants and priviledges.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-23-2006 07:57 AM
тАО11-23-2006 07:57 AM
Re: user constraints export / import
full=y