- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: export problems ?
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
тАО09-18-2002 07:36 AM
тАО09-18-2002 07:36 AM
export problems ?
I am doing an export based on schema from a production box that I need to get into a development box.
when trying to import the data, I get an error, because of child/parent relationship. I think the sql is trying to create a child table before its parent exists.
since I am new to oracle tools, could I export the data with constraints=NO, import the data in, then turn constraints ON on the new instance ? Is there a way to export the constraints only ?
We do not have access to the Unix box, and can not simply do a hot backup either. So, it will have to be done via export :-(((
Any help will be appreciated !!!
Henrique Silva
PS.: What is the CONSISTENT option for ? It says cross table consistency !!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-18-2002 07:51 AM
тАО09-18-2002 07:51 AM
Re: export problems ?
Import the parent table on its own
before the child table
imp file=mydata.dmp tables=parent_table
imp file=mydata.dmp tables=child_table
or do the import without constraints
imp file=mydata.dmp constraints=n rows=y indexes=y
then do the import with constraints only
imp file=mydata.dmp constraints=y rows=n indexes=n
quoting the manual on consistent:
"Specifies whether or not Export uses the SET TRANSACTION READ ONLY statement to ensure that the data seen by Export is consistent to a single point in time and does not change during the execution of the export command. You should specify CONSISTENT=Y when you anticipate that other applications will be updating the target data after an export has started."
Cheers
/Matt
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-18-2002 07:54 AM
тАО09-18-2002 07:54 AM
Re: export problems ?
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2002 03:55 AM
тАО09-19-2002 03:55 AM
Re: export problems ?
You could drop the target user and recreate it, a
"user" import (implies a user export) would then recreate all objects automatically with the inter table dependancies implemented at the end.
Your development environment must be quite similar to your production environment though (ie same tablespaces).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-19-2002 04:18 AM
тАО09-19-2002 04:18 AM
Re: export problems ?
Seems like you are importing into existing objects...
I would disable all constraints then reenable them after the import.
==============================
SQL> spool ./disable_constraints.sql
SQL> select 'alter table '||table_name||' disable constraint '||
constraint_name||';'
from user_constraints;
...
SQL>spool off
SQL>@./disable_constraints.sql
==============================
Then you do your import and re-enable the constraints.
NB. IMP with the INDEX=NO so that you don't have problems with the primary key during the first import. That is, import your data then import your indexes.
Hope this helps!
Regards
Yogeeraj