Meaningless Drivel is fun!*
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
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: 30146
    
150

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
how to use ProcessBuilder for executing a shell script from java?
Unix With Java....
tee not terminated
declaring the shell variable
porting a .bat file to unix