OraFAQ Forum: Server Utilities » Schema export in command prompt mode

Home » RDBMS Server » Server Utilities » Schema export in command prompt mode (Oracle 11.1.0.7.0, Windows XP)

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

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.

Code: [Select all] [Show/ hide]

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.

Code: [Select all] [Show/ hide]

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

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

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

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: 68758
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

Report message to a moderator

Previous Topic:	Flat file Tab Delimeter import Messed up with SQL Loader !!
Next Topic:	import problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 30 03:51:08 CDT 2025