
	Home > Ask the Oracle Experts > Database Design and Architecture Questions & Answers > Importing tables with integrity constraints

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

Importing tables with integrity constraints

EXPERT RESPONSE FROM: Brian Peasland

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Oracle tips, scripts, and expert advice

Digg This! StumbleUpon Del.icio.us

QUESTION POSED ON: 14 February 2008
I am using Oracle 8i in a Windows 2000 Server and importing a dump file to a new schema created in another machine. First I imported only the database structure without data, and then I imported only the data to the tables by the ignore=y option. As the tables have some integrity constraints, it gives lots of errors while importing.

Can I disable the constraints and triggers while importing? Is there any way to import data to an existing table if constraints are enabled? Which are the commands to disable the constraints? Will any data be duplicated if constraints are disabled?

EXPERT RESPONSE
I never would have imported the database structure first, and then the data. The primary reason is the integrity constraints you mentioned. If you import the structure and the data at the same time, you won't have this problem. Oracle won't enable the constraints until the tables in the schema are populated with data. Since you have the tables created, you will have to manually disable the constraints to perform the export. There is no command in the import utility to do this for you.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Database Design and Architecture
	Why am I getting an Oracle error when issuing the RECOVER DATABASE command?
	Can I add multiple datafiles and make use of all the temporary datafiles at the same time?
	What's the best tape backup strategy for 10g RAC?
	Checkpoint vs. commit process
	How does an INSERT/UPDATE statement behave when executed compared to a SELECT statement?
	Can I resize the SYSTEM tablespace?
	What is the difference between an instance and mounting in Oracle?
	How to implement a ref cursor called in a stored procedure
	In Oracle, does the number of columns in a table affect the performance during SELECT/INSERT/UPDATE?
	Allocating bytes as extents in Oracle

Oracle Database Administrator

What is the difference between a database engineer, architect and administrator?

Import on one table from dump file

Error during RMAN backup

Can I drop a column in SYS schema?

STATSPACK tool: transaction vs. execution measurement

Should I port from Microsoft Access?

Installing multiple Oracle homes

How can I find statistics on total memory usage and database connections?

Modifying SYS password in a RAC environment

How to create Datafiles in a Data Guard (10g) environment

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy