Database Import - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 22

Thread: Database Import

  1. #11
    Join Date
    Oct 2001
    Posts
    126
    If you use windows OS, you can open the file from notepad. On the unix OS, you can use "more" or "vi". The tablespace info is just right at the beginning of file.

    Susan

  2. #12
    Join Date
    Mar 2001
    Posts
    131
    Hello,

    U mean to say that i have to open export.dmp file in notepad in winOS. Are u sure ?


  3. #13
    Join Date
    Oct 2001
    Posts
    126
    I use textpad on Win OS.
    In your case, you can use 'head' command on the Unix.

    Susan

  4. #14
    Join Date
    Oct 2001
    Posts
    126
    I mix your post with another post. Sorry.

    Yes! The answer is using the notepad or any text editor. If you peformed a full export of the database, you will see the talespace structure right at the top.

    Susan

  5. #15
    Join Date
    Mar 2001
    Posts
    131
    Hello,

    Still my question is not answered ?

    I want to know the file name .......I thought export.dmp file is been read only by import utility. So please tell me which file i have to open it NOTEPAD. I am going to do it on WindowsNT.

  6. #16
    Join Date
    Mar 2001
    Posts
    144
    Yes dmp file is a binary file that is read by Oracle utilities. You can try and edit it with notepad but most of it will be garbage and very likely the dmp file will no longer be valid even if you do not save the file through notepad (I learned this the hard way).

    Try this:

    You are at the dos prompt:

    c:>
    c:>\export ORACLE_SID=
    c:>imp system/ file=export.dmp full=y indexfile=c:\fullschema.sql

    once the import has been completed edit the c:\fullschema.sql file with notepad for whatever changes you want to do or to find out the tablespaces info.

    Done.

    Just try that and see what happens. No data will get imported into the database when you use the indexfile parameter during import.


    This is what oracle writes in their manual:
    INDEXFILE
    Default: none

    Specifies a file to receive index-creation statements.

    When this parameter is specified, index-creation statements for the requested mode are extracted and written to the specified file, rather than used to create indexes in the database. No database objects are imported.

    If the Import parameter CONSTRAINTS is set to y, Import also writes table constraints to the index file.

    The file can then be edited (for example, to change storage parameters) and used as a SQL script to create the indexes.

    To make it easier to identify the indexes defined in the file, the export file's CREATE TABLE statements and CREATE CLUSTER statements are included as comments.

    Perform the following steps to use this feature:

    Import using the INDEXFILE parameter to create a file of index-creation statements.

    Edit the file, making certain to add a valid password to the connect strings.

    Rerun Import, specifying INDEXES=n.

    (This step imports the database objects while preventing Import from using the index definitions stored in the export file.)

    Execute the file of index-creation statements as a SQL script to create the index.

    The INDEXFILE parameter can be used only with the FULL=y, FROMUSER, TOUSER, or TABLES parameters.


    http://doc.oracle.com/cd_a91034/DOC/...02.htm#1005473

    [Edited by ramaral on 08-09-2002 at 01:30 PM]

  7. #17
    Join Date
    Oct 2001
    Posts
    126
    export.dmp is the default dump filename. I don't know your export filename. If you didn't specify any dump filename, then export.dmp will be the file you want to read.

    Go ahead to open this file and see if any information is useful for you.

    Susan

  8. #18
    Join Date
    Mar 2001
    Posts
    131
    Hi,


    I just went through the link of Oracle documentation, still there are two doubts,
    1. Will i get all tablespaces name from the file ?

    2. What happened after creating a tablespace i will rerun the full import with INDEX=Y ?

    Thanks,


  9. #19
    Join Date
    Mar 2001
    Posts
    144
    Yes you will get the tablespace name from the exp file.

    Once you get the schema information you can edit the fullschema.sql file for the tablespaces info making sure the datafile locations are fine for you server. Then you can run the fullschema.sql that you just finished editing in sqlplus and let it create the schemas and objects. Once this is done then import the dmp file with ignore=y

    ie.

    imp system/ file=export.dmp full=y ignore=y log=schemaimp.log

    Once completed,review the schemaimp.log to make sure the import was successful. You will see a number of imp-0015 errors. Most of them, if not all of them, are fine because those will be system objects that you have created from the database's initial creation and from the fullschema.sql file - those are nothing to worry about.

  10. #20
    Join Date
    Mar 2001
    Posts
    144
    alternatively you can also do this

    c:\imp system\ file=export.dmp full=y show=y log=export.log

    This will also spool out to the export.log your tablespace create statements without actually importing any data including datafile locations. You can actually run this one if you want because you will not have to edit it to remove the rem statements generated through the other method.

    Now that I look at the 2 methods this one might be better for you in the long run.





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