Regarding Oracle databases

[deepak.krishnan]

Hi friends

Is there any way to transport a oracle database that I made at home for my project, to the school computer???

 

[desertwind]

you can use export and import tools of oracle.

For exporting data

c:\> exp
for interactive dialogue

or
c:\> exp userid/password file=outputfile tables=(table1,table2,..) log=logfile

similarly for import

c:\> imp
for interactive dialog

or
c:\> imp userid/password file=inputfile tables=(table1,table2,..) log=logfile

 

[deepak.krishnan]

when I used :

c:\>exp

it asked for user name and password and then also for the following:

enter array fetch buffer size:4096 >
export file:EXPDAT.DMP>
<2>U<sers> or <3>T<ables> :<2>U >
Export table data <yes/no> : yes >
Compress extends <yes/no> : yes >

Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export specified tables via conventional path...
Table<T> or partition<T:P> to be exported: <Return to quit> >

What should I enter here and where will the file be exported to???(i.e where can I find the file???)

 

[deepak.krishnan]

Please help me fast....It is urgent!!!

 

[deepak.krishnan]

Hi
I exported the file. But the exported file is only about 4kb in size. My database consists of about 400 entries and so I have a doubt about the export.It showed that export completed with some warnings.....
So was the export successfull??? If so then why such a very low size???
Also will the import in my school computer be successfull??? ( I have oracle 9i and school computer has 8i)
I have my project display tomorrow and I badly need to get my database from my home to the school computer....
Please help me fast.