Dumb ORacle 8I question

[pattihiggins]

Ok
Here I am with Oracle 8I. I have Oracle applications 11I.
I have to copy a table from one database to another, because HR doesn't want to key these values in. Now my bright idea is to use Dataloader and use an excel spreadsheet. But How can I get the data out of the data base? When I look in DBA studio I see it. But I can't export because I don't have a mangement server. I can't find this table if I am in UNIX on the AIX box. So how can I go about this? Any ideas would be appreciated
Thanks
pahiggins

 

[lfoata]

I dont see why you need a management server et export a table.
On unix , open a terminal (or xterm or whatever).
Logon as oracle user
Set the ORACLE_SID to the instance name
type exp ENTER
the utility will ask you a few questions like what you want to export (choose TABLE).
ftp the output file to your other server,
then login as oracle
set the ORACLE_SID
edit the import file to change the tablespace_name
type imp ENTER
and then reply to the questions(straight-forward)

the import utility will recreate all the indexes and constraints.

If the table you are exporting is huge, you may want to export the table definition first (rows = no) and edit that file to change the tablespace_name if different. If the tablespace_name is different and you do not change it in the import file then, the table will be created in the default tablespace of the user used for the import.