OraFAQ Forum: Server Utilities » Import from Oracle7 to Oracle 10g

Home » RDBMS Server » Server Utilities » Import from Oracle7 to Oracle 10g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import from Oracle7 to Oracle 10g [message #244987]

Thu, 14 June 2007 16:09

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

Report message to a moderator

Re: Import from Oracle7 to Oracle 10g [message #244988 is a reply to message #244987]

Thu, 14 June 2007 16:18

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

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

Report message to a moderator

Re: Import from Oracle7 to Oracle 10g [message #244996 is a reply to message #244995]

Thu, 14 June 2007 17:08

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.

Report message to a moderator

Previous Topic:	Migration 10.1.0.3 on tru64 -> 10.2.0.3 RHEL4
Next Topic:	SQL * Loader Problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 00:56:12 CST 2024