Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 22nd, 2004, 03:26 AM
Authorized User
 
Join Date: Sep 2003
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
Default Create Oracle database using a script

Hi everyone,

I have a question regarding import of an Oracle database using a script. I have an Oracle database running on my system (Windows) and I have to export it to another machine using a script. I will personally have no access to that machine. I have to create a script along with an Oracle dump file that will export the database there.

Can someone point me to the best way of doing this? I do not have much experience with Oracle and am in a real dilemma.

Thanks,
Pankaj

 
Old June 22nd, 2004, 04:51 AM
Authorized User
 
Join Date: Apr 2004
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Do you really want to export the entire database? Or just a single schema of the database?

I assume you are being asked to create a dump file and a script that will import the dump file on the target database. What version of Oracle is present on both systems? What character sets are the two databases using?

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
 
Old June 22nd, 2004, 07:13 AM
Authorized User
 
Join Date: Sep 2003
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Justin,

Thanks for replying :-) The version of Oracle is 9i. I think I will have to create a database instance on the remote machine and import the dump file into it, or is there a better way.

The problem is that I will have no access to that machine. So I have to make this installation script as automatic as possible.

The character set that my source database is using is WE8MSWIN1252. However, I have to create the target database as well, so it should not be a problem, I think.

Thanks,

Sincerely,

Pankaj






Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create Captcha using VB Script compad Classic ASP Basics 2 September 12th, 2007 03:00 AM
ASP login script with Oracle Database Thamil Classic ASP Databases 5 March 13th, 2007 04:50 AM
Runing package script for Oracle Database Installe navedkhan ADO.NET 0 February 28th, 2007 04:33 AM
How to load & run a oracle script file? hapytran C# 0 October 12th, 2005 11:47 PM
Help with getting a script to create Friends_Data. linuxjr General .NET 2 March 25th, 2004 06:37 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.