OraFAQ Forum: Server Utilities » Question on export/import

Home » RDBMS Server » Server Utilities » Question on export/import (10.2.0.4.0 , Solaris 5.8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Question on export/import [message #533804]

Thu, 01 December 2011 06:19

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi,

I want list of schema objects (schema name--MATT) to export and import the same dump into another database.

1 DATABASE LINK
219 INDEX
194 PACKAGE
193 PACKAGE BODY
4 PROCEDURE
64 SEQUENCE
214 TABLE
15 TRIGGER
31 VIEW

Can anybody provide me the exact exp and imp command like what are all the pre-requisite check before running the command and the parameters we need to specify in the exp and imp command to make the task quick and without any errors?

say for example ;

exp system/oracle@tns file=schemaexp.dmp log=schemaexp.log owner=MATT rows=y ........

imp system/oracle@tns file=schemaexp.dmp log=schemaimp.log fromuser=MATT touser=MATT .........

Can anybody complete the exp and imp command based on the above requirement?

Thanks

Report message to a moderator

Re: Question on export/import [message #533813 is a reply to message #533804]

Thu, 01 December 2011 07:04

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The statements are correct.

Regards
Michel

Report message to a moderator

Re: Question on export/import [message #533817 is a reply to message #533813]

Thu, 01 December 2011 07:21

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Thanks Michel for your responds.

What i am asking is do i need to add parameters like statistics=none,constraints=N etc... ??

[Updated on: Thu, 01 December 2011 07:22]

Report message to a moderator

Re: Question on export/import [message #533824 is a reply to message #533817]

Thu, 01 December 2011 08:02

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

You will need to add parameters if you wish to use the features that get switched on by that parameters, if not then not.

Report message to a moderator

Previous Topic:	migrate table from 10g xe to oracle 9i
Next Topic:	return a column value using Sqlloader after loading

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 20 18:44:58 CDT 2025