Home » RDBMS Server » Server Utilities » Export using Batch but hiding cmd prompt  () 1 Vote
Export using Batch but hiding cmd prompt [message #398074] Wed, 15 April 2009 02:49 Go to next message
morad
Messages: 5
Registered: March 2009
Location: BANGLADESH
Junior Member
Hi friends,
I am using batch file to do export. But i want to hide cmd prompt while exporting. That means, command prompt screen will not appear while exporting an user.

Is it possible? If possible, Plese help me by giving instruction.

I am eagerly waiting for your respose.

Thanking you,
Morad
Re: Export using Batch but hiding cmd prompt [message #398077 is a reply to message #398074] Wed, 15 April 2009 02:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
echo off

Regards
Michel
Re: Export using Batch but hiding cmd prompt [message #398079 is a reply to message #398077] Wed, 15 April 2009 03:01 Go to previous messageGo to next message
morad
Messages: 5
Registered: March 2009
Location: BANGLADESH
Junior Member
Hi Michel,
Thank you very much for immediate reply.
I have tried to export using batch file adding echo off in first
line.
Now it hides the user name and passowrd, but still it is showing the export activitis (the tables are exporting) in cmd prompt.

How can i hide the cmd prompt while exporting.

Hope you help me. I am eagerly witing for you reply.

Thanking you,
Morad
Re: Export using Batch but hiding cmd prompt [message #398080 is a reply to message #398079] Wed, 15 April 2009 03:07 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, you can not do that - BAT file runs in command prompt window and that's how it is - you can not "hide" it. It would be as if you wanted to write text into MS Word, but would also like Word not to appear on the screen.
Re: Export using Batch but hiding cmd prompt [message #398091 is a reply to message #398080] Wed, 15 April 2009 04:06 Go to previous messageGo to next message
morad
Messages: 5
Registered: March 2009
Location: BANGLADESH
Junior Member
Hi,
Ok, thank you very much.

Thanking you,
Morad.
Re: Export using Batch but hiding cmd prompt [message #398154 is a reply to message #398079] Wed, 15 April 2009 06:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Something like this?
C:\Documents and Settings\oracle>type somefile.bat
@echo off
exp  mahesh/tiger@chum file=somedmp.dmp

C:\Documents and Settings\oracle>somefile > somelog.log 2>&1


C:\Documents and Settings\oracle>type somelog.log

Export: Release 10.2.0.1.0 - Production on Wed Apr 15 07:53:02 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user MAHESH
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user MAHESH
About to export MAHESH's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export MAHESH's tables via Conventional Path ...
. . exporting table          CREATE$JAVA$LOB$TABLE          0 rows exported
. . exporting table                    DBMSLOBDEMO        117 rows exported
. . exporting table                           DEPT          4 rows exported
. . exporting table                            EMP         14 rows exported
. . exporting table                       EMPPHONE         14 rows exported
. . exporting table                       PHNO_TAB         55 rows exported
. . exporting table                   JAVA$OPTIONS          1 rows exported
. . exporting table                     NESTEDDEMO          0 rows exported
. . exporting table                        DEPTH_2          0 rows exported
. . exporting table                        DEPTH_1          0 rows exported
. . exporting table                          PHONE         56 rows exported
. . exporting table                        UTLDEMO        288 rows exported
. exporting synonyms
. exporting views
. exporting stored procedures
. exporting operators
. exporting referential integrity constraints
. exporting triggers
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting statistics
Export terminated successfully without warnings.


[Updated on: Wed, 15 April 2009 07:42]

Report message to a moderator

Re: Export using Batch but hiding cmd prompt [message #398161 is a reply to message #398154] Wed, 15 April 2009 07:50 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
somefile > somelog.log 2>&1

Aha! Nice one!

Previous Topic: DBMS_DATAPUMP - EXPORT, TRANSPORTABLE - missing info
Next Topic: Import ...
Goto Forum:
  


Current Time: Fri Dec 02 16:37:40 CST 2016

Total time taken to generate the page: 0.35955 seconds