Trace: • Oracle Database - Installation of 11gR1/R2 on Windows • Essbase - Servers • PowerCenter - Installation and Configuration (8.6.1 for Windows 32Bit) • SQL - Left (Outer) Join • SQL - Full Outer Join • Essbase - Storage Properties • OBIEE - Quick Skin and Style customization • OC4J - Creation of a Windows Service with Javaservice • OBIEE 10G - Linux OEL 5 x86 Installation version 10.1.3.4.1 • Oracle - Import/Export
You are here: Home » Database management system (DBMS) » Oracle Database » Oracle - Import/Export
Table of Contents

Oracle - Import/Export

Sample code

imp dq_src/dq_src@<ORCL or your database service name> file=<PATH>\dq_src.dmp full=y

Help

imp help=y
exp help=y

Copy User Schema to an other

imp SH_TARGET/SH_TARGET FROMUSER=SH TOUSER=SH_TARGET
  • Bookmark "Oracle - Import/Export" at del.icio.us
  • Bookmark "Oracle - Import/Export" at Digg
  • Bookmark "Oracle - Import/Export" at Ask
  • Bookmark "Oracle - Import/Export" at Google
  • Bookmark "Oracle - Import/Export" at StumbleUpon
  • Bookmark "Oracle - Import/Export" at Technorati
  • Bookmark "Oracle - Import/Export" at Live Bookmarks
  • Bookmark "Oracle - Import/Export" at Yahoo! Myweb
  • Bookmark "Oracle - Import/Export" at Facebook
  • Bookmark "Oracle - Import/Export" at Yahoo! Bookmarks
  • Bookmark "Oracle - Import/Export" at Twitter
  • Bookmark "Oracle - Import/Export" at myAOL
 
database/oracle/importexport.txt · Last modified: 2010/01/23 23:50 by gerardnico