Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Location
    In your thoughts
    Posts
    195

    Unanswered: Get Table Structure

    I can't seem to create a database link so that I can copy a table from one database to another. Is there a way to copy it's structure instead? Is there a tool that will automatically generate a "Create Table" script so that I can modify it to create the table I need in the proper database? All I need to do is copy the table's structure from one database to another and preferably without database links. I can't seem to get those to work. Thanks, Jeremy
    Nothing better than a good ride.

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    exp <user>/<pwd>@sid file=expdat.dmp tables=(table1, table2,... table<n>) rows=n buffer=4000000 log=explogfile.log

    you get the ddl stmts for the selected tables and can then

    imp <user>/<pwd>@sid2 file=expdat.dmp buffer=4000000

    all the tables in exdat.dmp file will be imported into sid2 without rows

  3. #3
    Join Date
    Jan 2003
    Location
    Woking
    Posts
    107
    Originally posted by osy45
    exp <user>/<pwd>@sid file=expdat.dmp tables=(table1, table2,... table<n>) rows=n buffer=4000000 log=explogfile.log

    you get the ddl stmts for the selected tables and can then

    imp <user>/<pwd>@sid2 file=expdat.dmp buffer=4000000

    all the tables in exdat.dmp file will be imported into sid2 without rows
    Hi,
    If you wanted to get a " create table " script, you can try TOAD.

    it is available in www.quest.com
    nn

Posting Permissions

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