Export using Batch but hiding cmd prompt [message #398074] |
Wed, 15 April 2009 02:49 |
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 #398079 is a reply to message #398077] |
Wed, 15 April 2009 03:01 |
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 #398154 is a reply to message #398079] |
Wed, 15 April 2009 06:56 |
|
Mahesh Rajendran
Messages: 10708 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
|
|
|
|