Imp-00015 following statement failed because the object already exists

This is an Import Message generated by the Import utility. For more information about this utility, refer to Oracle Database Utilities.

What is the cause of IMP-00015 from Oracle 11g ?

Import failed to create an object because it already exists.

How to deal with IMP-00015 from Oracle 11g ?

Specify IGNORE=Y to ignore such errors and import rows even when tables are not created because they already exist.

How to deepen your knowledge about Oracle?

There is no magic formula nor quick fix. You can train yourself with books and get an advantage over your competitors by developing a set of skills highly sought throughout the world. Niels Bohr saw an expert as "a person who has found out by his own painful experience all the mistakes that one can make in a very narrow field". So why not you? Be an expert!
Here are some books about Oracle you should know for a start.

OCP: Oracle Database 12c Administrator Certified Professional Study Guide - $59.99
from: RedShelf

Oracle Database 11g The Complete Reference (Oracle Press)

The Definitive Guide to Oracle Database 11g.
Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included.

Author:

Oracle Database 11g SQL (Oracle Press)

Write powerful SQL statements and PL/SQL programs.
Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL.

Author: Jason Price

Oracle Database 11g Release 2 Performance Tuning Tips & Techniques (Oracle Press)

Implement Proven Database Optimization Solutions.
Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 11g Release 2 Performance Tuning Tips & Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to find and fix bottlenecks, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide.

Author: Richard J. Niemiec

OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) (Oracle Press)

A Fully Integrated Study System for OCA Exam 1Z0-047.
Prepare for the Oracle Certified Associate SQL Certified Expert exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exam 1Z0-047.

Author: Steve O'Hearn

Contacting Oracle support services ?

Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.

Linked Error Messages

  • IMP-00007 must be a DBA to import objects to another user's account
  • IMP-00008 unrecognized statement in the export file: string
  • IMP-00009 abnormal end of export file
  • IMP-00010 not a valid export file, header failed verification
  • IMP-00011 formatted table data not currently supported
  • IMP-00012 invalid export mode ( character ) in header
  • IMP-00013 only a DBA can import a file exported by another DBA
  • IMP-00014 option " string " is needed, but not present in database
  • IMP-00016 required character set conversion (type number to number ) not supported
  • IMP-00017 following statement failed with ORACLE error number :
  • IMP-00018 partial import of previous table completed: number rows imported
  • IMP-00019 row rejected due to ORACLE error number
  • IMP-00020 long column too large for column buffer size ( number )
  • IMP-00021 INCTYPE parameter is obsolete
  • IMP-00022 failed to process parameters, type 'IMP HELP=Y' for help
  • IMP-00023 Import views not installed, please notify your DBA

Find other oracle error messages