| Schema export in command prompt mode [message #538458] |
Fri, 06 January 2012 04:34  |
 |
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
|
Senior Member |
|
|
Hi,
I want to take a export of schema JACK of size 700 MB which contains list of objects in it.
SQL> select count(*),object_type from dba_objects where owner='JACK' group by object_type;
COUNT(*) OBJECT_TYPE
---------- -------------------
207 INDEX
4 PROCEDURE
190 TABLE
80 VIEW
3 SYNONYM
67 SEQUENCE
6 rows selected.
The export command i am going to use is as below.
exp system/oracle@ORCL1 file=schemaexp.dmp log=schemaexp.log owner=JACK rows=y direct=y
grants=N constraints=y COMPRESS=N buffer=100000000 RECORDLENGTH=64000
I have one question before running this export.
Is it possible to take this schema export in windows command prompt mode and any guess
how long it would take to complete the export ?Because based on the time it takes, i am going
to perform the export in windows command prompt.
Also can anybody confirm the above export command is correct ?
Thank you
[Updated on: Fri, 06 January 2012 04:40] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Schema export in command prompt mode [message #538468 is a reply to message #538460] |
Fri, 06 January 2012 06:12  |
|
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
|
Senior Member |
|
|
Michel,
Thank you for your answers.
Can i put the parameter as index=N and grant=N in exp command as there are more than 200 indexes to be created .
We can create the indexes and grants after the export gets over.
Would that be a better way to speedup the export by adding these 2 parameters in exp command?
Thank you
[Updated on: Fri, 06 January 2012 06:14] Report message to a moderator |
|
|
|
| Re: Schema export in command prompt mode [message #538474 is a reply to message #538468] |
Fri, 06 January 2012 06:39 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:Can i put the parameter as index=N and grant=N in exp command as there are more than 200 indexes to be created .
Yes you can.
Quote:We can create the indexes and grants after the export gets over.
Which is what import will do if you include them in the export file.
Quote:Would that be a better way to speedup the export by adding these 2 parameters in exp command?
These 2 options take very little time to export.
I'd let them unless I know there are useless.
Index does not export the complete index, it exports only the definition of the index.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
