Nov 12, 2011

Export and Import Data from XML Schema Database

UserName :  sys as dba   passward:   oracle

SQL> show parameter db_name;
It will shows database name

SQL> exit;

Q> How to setup my SID?

A>  set oracle_sid <2nd DBname>



export from user oe to user scott
Export: Release 10.1.0.4.2 - Production on Fri Nov 11 17:41:39 2011
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username: oe/oe
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Enter array fetch buffer size: 4096 >
Export file: EXPDAT.DMP > c:\ware.dmp
(2)U(sers), or (3)T(ables): (2)U > t
Export table data (yes/no): yes > Y
Compress extents (yes/no): yes > Y
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
TA
About to export specified tables via Conventional Path ...
Table(T) or Partition(T:P) to be exported: (RETURN to quit) > WAREHOUSES
. . exporting table                     WAREHOUSES          9 rows exported
Table(T) or Partition(T:P) to be exported: (RETURN to quit) >
Export terminated successfully without warnings.
C:\


***************************************************
TO IMPORT DATA FROM C:\WARE.DMP FILE TO USER SCOTT
C:\> IMP SCOTT/TIGER FILE=C:\WARE.DMP FULL=Y










No comments:

OraApps Search

Custom Search

Search This Blog