Home » RDBMS Server » Server Utilities » Schema export in command prompt mode (Oracle 11.1.0.7.0, Windows XP)
Schema export in command prompt mode [message #538458] Fri, 06 January 2012 04:34 Go to next message
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 #538460 is a reply to message #538458] Fri, 06 January 2012 04:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is it possible to take this schema export in windows command prompt mode

Yes.

Quote:
any guess how long it would take to complete the export ?

No.

Quote:
Also can anybody confirm the above export command is correct ?

It is (syntaxically) correct (as far as my eyes can see).

Regards
Michel
Re: Schema export in command prompt mode [message #538468 is a reply to message #538460] Fri, 06 January 2012 06:12 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Flat file Tab Delimeter import Messed up with SQL Loader !!
Next Topic: import problem
Goto Forum:
  


Current Time: Thu Mar 28 04:53:00 CDT 2024