Unloading data to delimited ascii file quickly
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Unloading data to delimited ascii file quickly

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Posts
    6
    Does Oracle have the ability to do a massive unload
    of data to a delimited ascii file like it does with the sqlldr tool for loading. I know I can do an export but I need the format
    to be in ascii or del ascii so I can load it into another DBMS
    and using select * will take forever with gigabyte tables

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check this thread regarding this issue.

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=7875[/url]

    There are a number of pretty good suggestions and links.
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jan 2001
    Posts
    18
    You can download a powerful database movement and migration tool Chyfo at [url]http://www.ispirer.com/chyfo.html.[/url]

    This tool facilitates the movement of tables between different or same database systems. It exports a table to a text file (CSV, TAB and fixed length are supported formats) and generates DDL and import-load scripts for specified database.

    The tool is especially designed for Oracle and IBM DB2 databases but can be also very helpful for other databases such as Microsoft SQL Server, Sybase, Informix, MySQL and others.

    The tool can export data from any database accessible through ODBC interface. It has a lot of features useful for DBAs:

    - This is a comprehensive command prompt tool. So you can create various scripts to automate your work. The tool allows you creating scripts for regular data moving, loading into databases or datawarehouses.
    - You can provide a table name or any SELECT statement (from the command prompt or a file) specifying the data to be exported.
    - You can provide a list of columns to be excluded from converting, start row and number of rows to be exported.
    - The tool generates native CREATE TABLE and CREATE INDEX scripts for Oracle, IBM DB2 and MS SQL Server.
    - The tool generates loading scripts for specified database (control files for Oracle SQL Loader, IMPORT and LOAD scripts for IBM DB2).
    - Movement of LOBs are fully supported.
    - Many others useful features such setting names for output table, schema, files, file directories and others.

    Best regards, Dmitry

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