Home » RDBMS Server » Server Utilities » Question on export/import (10.2.0.4.0 , Solaris 5.8)
Question on export/import [message #533804] Thu, 01 December 2011 06:19 Go to next message
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
Re: Question on export/import [message #533813 is a reply to message #533804] Thu, 01 December 2011 07:04 Go to previous messageGo to next message
Michel Cadot
Messages: 66801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The statements are correct.

Regards
Michel
Re: Question on export/import [message #533817 is a reply to message #533813] Thu, 01 December 2011 07:21 Go to previous messageGo to next message
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 Go to previous message
ThomasG
Messages: 3210
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.

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


Current Time: Mon Jan 27 19:45:23 CST 2020