aspose file tools*
The moose likes Oracle/OAS and the fly likes Ksh script to export and import from one schema to another Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Ksh script to export and import from one schema to another" Watch "Ksh script to export and import from one schema to another" New topic
Author

Ksh script to export and import from one schema to another

Stella Harding
Greenhorn

Joined: Sep 13, 2004
Posts: 1
Anyone with any suggestions...they are all welcome. I'm just a beginner with Ksh scripting.

What I need to do is be able to put all these in one script:
1. gzexp schema_#1
2. truncate(drop) schema_#2
3. gzimp schema_#2

Does any of this make sense to anyone?

Thanks
-Stella
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29233
    
138

Stella,
Welcome to Javaranch! We do have a Linux/UNIX forum, so if this gets away from Oracle and too much into scripting, I'll move it there.

A korn shell script is basically just a sequence of commands. So you need to figure out how to run those commands at the command line (rather than from within Oracle.) I don't have my Oracle docs with me, but I imagine it is in there.

I would advise trying the commands one at a time at the command line. Once you have each one working, add it to a file. When you are done with the third one, you have a script! Just make sure the script has execute permission and you're done.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Ksh script to export and import from one schema to another
 
Similar Threads
tee not terminated
Unix With Java....
declaring the shell variable
how to use ProcessBuilder for executing a shell script from java?
porting a .bat file to unix