Copy oracle table in file.

[Projjwal]

Hi fredz... I used oracle 9i for last couple of weeks but i recently install oracle 10g on my computer.But the most imporatent tables of oracle for newuser the employee,depertment table is not in oracle 10g.Is there any way to copy oracle tables into a file(9i) & then attach thouse tables into oracle(10g)?

So, nobody knew about it? pls help it's urgent.

 

[it_waaznt_me]

Use exp for exporting the database and imp for importing the database .. Its very easy to do ..

[Edit] Check this for reference ..

 

[Projjwal]

i think it will work for ora9i.I tried it in ora10g but it not worked ,but it has graphical option to do such kind of thing. Thx to u.........

 

[bulbuljb]

can anyone recommend some site where I can get Info about Orcale 10 g .