Home » RDBMS Server » Backup & Recovery » Db export/import
Db export/import [message #199533] Wed, 25 October 2006 01:00 Go to next message
mavericks
Messages: 4
Registered: October 2006
Junior Member
I am exporting a database as one user, is it possible for me to import the same database as different user.
Re: Db export/import [message #199536 is a reply to message #199533] Wed, 25 October 2006 01:14 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

SQL> host exp scott/tiger tables=avgsal

Export: Release 10.1.0.2.0 - Production on Wed Oct 25 10:12:30 2006

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                         AVGSAL          5 rows exported
Export terminated successfully without warnings.

SQL> host imp tester/tester

Import: Release 10.1.0.2.0 - Production on Wed Oct 25 10:12:38 2006

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options

Import file: EXPDAT.DMP >

Enter insert buffer size (minimum is 8192) 30720>

Export file created by EXPORT:V10.01.00 via conventional path

Warning: the objects were exported by SCOTT, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
List contents of import file only (yes/no): no > n

Ignore create error due to object existence (yes/no): no > n

Import grants (yes/no): yes > y

Import table data (yes/no): yes > y

Import entire export file (yes/no): no > y

. importing SCOTT's objects into TESTER
. . importing table                       "AVGSAL"          5 rows imported
Import terminated successfully without warnings.

SQL>



Re: Db export/import [message #199556 is a reply to message #199536] Wed, 25 October 2006 01:55 Go to previous messageGo to next message
Littlefoot
Messages: 20894
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Or, shortly (perhaps easier to read than the whole screen output):

OS> EXP scott/tiger TABLES=employees FILE=emp.dmp
OS> IMP mike/lion FILE=emp.dmp

Also, you might want to read documentation about Oracle Data Pump (or, if you are on earlier Oracle version, check documentation about Export and Import utilities).
Re: Db export/import [message #205450 is a reply to message #199533] Fri, 24 November 2006 23:58 Go to previous messageGo to next message
rmdxb
Messages: 4
Registered: November 2006
Location: INDIA
Junior Member

hi friends

i m new in this forums, i have some difficulty when i export my data. error is appear as following :

error-00002 data could not exported
error- 00000 export terminated unsuccessfully

i have checked our filesize but its not exceed to 2g,afterthat i got error.

pls need your help

regrds
rmdxb
Re: Db export/import [message #205452 is a reply to message #205450] Sat, 25 November 2006 00:03 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

can you post ur export scritps.

.... what commmand your using for export.

regards
Taj
Re: Db export/import [message #205456 is a reply to message #205452] Sat, 25 November 2006 00:16 Go to previous messageGo to next message
rmdxb
Messages: 4
Registered: November 2006
Location: INDIA
Junior Member

hi taj

i posted following scripts for export data on unix 7.3

$ exp orion/orion file=filename.dmp owner=orion log=orion.log

and last i got error

regards
rmdxb
Re: Db export/import [message #205457 is a reply to message #205456] Sat, 25 November 2006 00:27 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi rajesh

check ur dump or any other trace file ( udump folder) generated during error...

bcoz ur scirpts is fine.


hope this helps
Taj
Re: Db export/import [message #205462 is a reply to message #205457] Sat, 25 November 2006 00:54 Go to previous messageGo to next message
rmdxb
Messages: 4
Registered: November 2006
Location: INDIA
Junior Member

hi taj

but where is located dump folder

in /oracle/bin

regard
regards
rmdxb
Re: Db export/import [message #205465 is a reply to message #205462] Sat, 25 November 2006 01:17 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

oracle-home/admin/"db_name"\bdump
udump
cdump


hope this helps
Taj
Re: Db export/import [message #205469 is a reply to message #205465] Sat, 25 November 2006 01:34 Go to previous message
rmdxb
Messages: 4
Registered: November 2006
Location: INDIA
Junior Member

hi taj

i will send to my log file to describe properly
meanwhile i check to udump folder

regards
rmdxb

Previous Topic: ORA-28546
Next Topic: Flash Recovery Area
Goto Forum:
  


Current Time: Mon Dec 05 09:14:51 CST 2016

Total time taken to generate the page: 0.04883 seconds