Regarding Oracle databases

Discussion in 'QnA (read only)' started by deepak.krishnan, Dec 7, 2006.

Thread Status:
Not open for further replies.
  1. deepak.krishnan

    deepak.krishnan New Member

    Joined:
    Jan 11, 2005
    Messages:
    423
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Palakkad/Bangalore
    Hi friends

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

    desertwind New Member

    Joined:
    Nov 2, 2004
    Messages:
    1,096
    Likes Received:
    10
    Trophy Points:
    0
    Location:
    Hyderabad
    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
     
  3. OP
    OP
    deepak.krishnan

    deepak.krishnan New Member

    Joined:
    Jan 11, 2005
    Messages:
    423
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Palakkad/Bangalore
    when I used :

    c:\>exp

    it asked for user name and password and then also for the following:
    Code:
    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???)
     
  4. OP
    OP
    deepak.krishnan

    deepak.krishnan New Member

    Joined:
    Jan 11, 2005
    Messages:
    423
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Palakkad/Bangalore
    Please help me fast....It is urgent!!!
     
  5. OP
    OP
    deepak.krishnan

    deepak.krishnan New Member

    Joined:
    Jan 11, 2005
    Messages:
    423
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Palakkad/Bangalore
    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.
     
Thread Status:
Not open for further replies.

Share This Page