Data export/import problem.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Data export/import problem.

  1. #1
    Join Date
    Jul 2004
    Location
    india
    Posts
    13

    Data export/import problem.

    hi every1 here
    this is my first posting n i expect ur co-ordination if my question is upto ur level.

    my problem is described as.
    First I export data from FTP site to a server(nothing particular just common spare server) and then i import this data into my oracle server where my oracle enterprise is running.

    I keep tranferring data about two time a day.First time i export it in morning tht is abt 100-150 MB arhived data.When i export data second time..it takes data (arhived file) from starting that is thata data also gets exported again that is already recivede in morning. Is there any alternative that i should export that file to my server without taking the data that is already exported first time.
    I only want the differential i.e the difference of data (data that is uploaded after first shift)

    As my boss has put me to handle oracle server i donnt know n othing..n he has ordered me to take me only as future DBA of company as a dummy DBA ...still m doing woteva i can..despite no help

    Thx in advance !!
    Please do help.

  2. #2
    Join Date
    Oct 2002
    Posts
    109

    Re: Data export/import problem.

    Hi Friend
    Can u tell me that in which format u export the data from FTP site?And how u export this?
    where u store your this data in your spare sever?
    and do not worry about bosses,they are meant for abuses.......

    praveen


    Originally posted by secureall
    hi every1 here
    this is my first posting n i expect ur co-ordination if my question is upto ur level.

    my problem is described as.
    First I export data from FTP site to a server(nothing particular just common spare server) and then i import this data into my oracle server where my oracle enterprise is running.

    I keep tranferring data about two time a day.First time i export it in morning tht is abt 100-150 MB arhived data.When i export data second time..it takes data (arhived file) from starting that is thata data also gets exported again that is already recivede in morning. Is there any alternative that i should export that file to my server without taking the data that is already exported first time.
    I only want the differential i.e the difference of data (data that is uploaded after first shift)

    As my boss has put me to handle oracle server i donnt know n othing..n he has ordered me to take me only as future DBA of company as a dummy DBA ...still m doing woteva i can..despite no help

    Thx in advance !!
    Please do help.

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    If all u need is changed data every day, then u can look into replication. You can set up replication to replicate only changed data from the last replication or the whole table as required.

    http://download-west.oracle.com/docs...a96567/toc.htm
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Oct 2002
    Posts
    109
    Hi Adweri
    the page u wrote doesnot open?
    can u recheck th esame

    praveen

    Originally posted by adewri
    If all u need is changed data every day, then u can look into replication. You can set up replication to replicate only changed data from the last replication or the whole table as required.

    http://download-west.oracle.com/docs...a96567/toc.htm

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Just register urself if it asks for username and password... its free and will be helpful in future.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  6. #6
    Join Date
    Jul 2004
    Location
    india
    Posts
    13

    here it is..

    ya praveen..
    thx first of all for attending me yaar..m quite illiterate n even bugg u for minimal commands.
    scene is like this now
    ITS MUCH EASIER NOW
    i have pasted the whole batch file

    c:
    cd c:\program files\winrar\

    winrar x -y H:xxx.dmp.gz D:\folder

    dir D:\folder >> c:\log\log.txt

    sqlplus ***/***@DBase @D:\RESTSCHEDULE\truncate.SQL

    imp **/**@DB file=D:\folder\exp_tables.dmp log=D:\exp_tables_imp.log buffer=3000000 ignore=y grants=n TABLES=table names..

    sqlplus/nolog @D:\RESTSCHEDULE\refresh.sql

    sqlplus/nolog @D:\RESTSCHEDULE\query2.sql

    i run this file here at spare server. n after it is downloaded..abt 150 mb comes to 1.7 gb size
    n then i transfer it to oracle server.

    now tell me plz at the earliest.

    regards.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width