Results 1 to 6 of 6

Thread: Moving files

  1. #1
    Join Date
    Jun 2006
    Posts
    2

    Unanswered: Moving files

    I'm trying to move some files from a test database to a production database. What is the best method?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >What is the best method?
    Floppy disk & sneakernet is one option.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2006
    Posts
    2

    Moving files

    Would "FTP" work also? Or couldn't I just simply copy from one db to another?

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    the possibilities are limitless.
    ftp scp dblink copy-command cut/paste NFS-mount type-in-by-hand

    please don't say you are referring to datafiles.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Jun 2006
    Posts
    1
    Which data you want to transfer (tables, tabledata, views ...)?
    In a Oracle environment you can't transfer data of any kind by copying files.

  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    If the OP comes from an ancient database systems (such as dBase III) where RDBMS term table was represented by actual file which could be seen using, for example, Windows Explorer, then his question might actually be "How to transfer several tables from one system to another?".

    If that's the case, then the answer could be "using Oracle export and import utilities" or "copying data through database link".

Posting Permissions

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