Home » RDBMS Server » Server Utilities » Import from Oracle7 to Oracle 10g
Import from Oracle7 to Oracle 10g [message #244987] Thu, 14 June 2007 16:09 Go to next message
10gnewbienewguy
Messages: 4
Registered: May 2007
Location: None
Junior Member

Hi there,

We are about to move from Oracle 7 on IBM AIX platform to Oracle 10G server. I have been instructed to import as a test a couple of tables from the Oracle 7 system to our new Oracle 10G box which runs on a linux server.

I am completely new to RedHat linux and usually use Windows platforms.

What i did was export a table into my directory on the oracle 7 server then ftp accross to the new redhat server. I can see the file on the server but how do i import.

If i want to import on the oracle 7 server i simply SU - Myname and then run the following command
imp/
"filename.dmp"

However after i have FTP's the file i cant seem to import. Does Redhat support the Imp/ or imppd command?

What is the best way to imort one table from Oracle 7 server to a redhat linux box?

Any replies greatly appreciated
Re: Import from Oracle7 to Oracle 10g [message #244988 is a reply to message #244987] Thu, 14 June 2007 16:18 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
set the ORACLE_SID using command

export ORACLE_SID=mydb then

use it as sample

imp user/password file=myfile.dmp CONSTRAINTS=N IGNORE=YES  ROWS=Y statistics=none INDEXES=N TABLES=employees log=2005_q1.log


http://orafaq.com/faqiexp.htm

[Updated on: Thu, 14 June 2007 16:20]

Report message to a moderator

Re: Import from Oracle7 to Oracle 10g [message #244995 is a reply to message #244987] Thu, 14 June 2007 16:59 Go to previous messageGo to next message
10gnewbienewguy
Messages: 4
Registered: May 2007
Location: None
Junior Member

DreamZ where exactly do i type this in as i said i'm completely new to Oracle & redhat, Quite a learning curve. I have very limited knowledge and basically know how to traverse/Navigate through directories, Smit, Vi and run a few scripts however that's about the level of my expertise as yet.

The test table i am trying to import is called work_sets
like i say i FTP'd the file to the RedHat server already so i assume all this is to be done at the shell? (command prompt as i am used to in windows) on the redhat server.
If this is the case under Root or SU'd as a user?

Does all this get typed in the RedHat server?

set the ORACLE_SID using command

export ORACLE_SID=mydb then

use it as sample

imp user/password file=myfile.dmp CONSTRAINTS=N IGNORE=YES ROWS=Y statistics=none INDEXES=N TABLES=employees log=2005_q1.log



Thanks very much for the expedient reply
Re: Import from Oracle7 to Oracle 10g [message #244996 is a reply to message #244995] Thu, 14 June 2007 17:08 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
f this is the case under Root or SU'd as a user?


AS A USER ORACLE ..

and also check the persmissions on files which you copied?
$ ls -ll
total 23786792
-rw-r--r--   1 oracle   dba      38808215 Jun 14 17:33 2000_q1.log
-rw-r--r--   1 oracle   dba          602 Jun 14 11:56 2000_q2.log
-rw-r--r--   1 oracle   dba          541 Jun 14 11:59 2000_q3.log
-rw-r--r--   1 oracle   dba          602 Jun 14 11:59 2000_q4.log


like this it should be user who will operate oracle not as root.
Previous Topic: Migration 10.1.0.3 on tru64 -> 10.2.0.3 RHEL4
Next Topic: SQL * Loader Problem
Goto Forum:
  


Current Time: Tue Dec 06 08:24:54 CST 2016

Total time taken to generate the page: 0.12036 seconds