File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31069
    
232

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