Results 1 to 10 of 10

Thread: convert a dmp into a sql file

  1. #1
    Join Date
    May 2003
    Posts
    33

    convert a dmp into a sql file

    Is that practicable?

  2. #2
    Join Date
    Mar 2003
    Posts
    468
    you can extract the DDL from a dmp file into SQL statements through the use of the SHOW=y option in the imp command. as far as the individual data inside the tables the answer is no.

  3. #3
    Join Date
    May 2003
    Posts
    33
    in that case, how the appropriate command is?

  4. #4
    Join Date
    May 2003
    Posts
    14
    The command is (along with whatever import params you want):

    imp show=y file=filename.dmp

  5. #5
    Join Date
    May 2003
    Posts
    33
    i put this in the command line

    imp 'system/sample2@sample as sysdba' show=y file=sample.dmp full=y

    and everything it worked properly.

    The problem is if i could store allk these sql statements in a sql file.
    Last edited by dominant; 07-16-2003 at 01:58 AM.

  6. #6
    Join Date
    Jul 2003
    Posts
    2
    Have you tried this :
    imp 'system/sample2@sample as sysdba' show=y file=sample.dmp full=y > yourFile.sql

  7. #7
    Join Date
    May 2003
    Posts
    33
    the generated sql file is always null

  8. #8
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Specify INDEXFILE = file.sql in your IMP command to get the script file.

  9. #9
    Join Date
    May 2003
    Posts
    33
    everything worked fine, but is there any good utility to convert the file into a mysql dump file?

  10. #10
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

Posting Permissions

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