Professional Web Applications Themes

Can't import from 8.05 to 9.3i need help - Oracle Server

Hi guys, Firstly let me apologise for my complete lack of knowledge in terms of oracle but I have a job to do and well I'm struggling to do it to be honest. I have an export dump from an Oracle 8 db, that I need to get into a new 9i instance. The problem is that the old export wants to create dictionary manged tablespaces and the new db uses locally manged tablesapces. All i get at the moment is "cannot create dictionary manged tablespaces" error messages. Can you tell me what I need to do to overcome this ...

  1. #1

    Default Can't import from 8.05 to 9.3i need help


    Hi guys,

    Firstly let me apologise for my complete lack of knowledge in terms
    of oracle but I have a job to do and well I'm struggling to do it to
    be honest.

    I have an export dump from an Oracle 8 db, that I need to get into a new
    9i instance. The problem is that the old export wants to create
    dictionary manged tablespaces and the new db uses locally manged
    tablesapces.

    All i get at the moment is "cannot create dictionary manged tablespaces"
    error messages.

    Can you tell me what I need to do to overcome this problem in simple
    steps if possible please.

    Thanks in advance for any help offered,

    :)

    --
    Posted via [url]http://dbforums.com[/url]
    splashy Guest

  2. #2

    Default Re: Can't import from 8.05 to 9.3i need help

    splashy wrote:
    > Hi guys,
    >
    > Firstly let me apologise for my complete lack of knowledge in terms
    > of oracle but I have a job to do and well I'm struggling to do it to
    > be honest.
    >
    > I have an export dump from an Oracle 8 db, that I need to get into a new
    > 9i instance. The problem is that the old export wants to create
    > dictionary manged tablespaces and the new db uses locally manged
    > tablesapces.
    >
    > All i get at the moment is "cannot create dictionary manged tablespaces"
    > error messages.
    >
    > Can you tell me what I need to do to overcome this problem in simple
    > steps if possible please.
    >
    > Thanks in advance for any help offered,
    >
    > :)
    >
    > --
    > Posted via [url]http://dbforums.com[/url]

    Manually create the tablespaces prior to the import.

    CREATE TABLESPACE FOOBAR ......


    Then include "IGNORE=YES" when doing the import.

    Anna C. Dent Guest

  3. #3

    Default Re: Can't import from 8.05 to 9.3i need help

    "splashy" <member32127dbforums.com> wrote in message
    news:3054675.1056836169dbforums.com...
    > Can you tell me what I need to do to overcome this problem in simple
    > steps if possible please.
    ignore=y
    destroy=n

    --
    Cheers
    Nuno Souto
    [email]wizofoz2k.au.nosp[/email]am


    Noons Guest

  4. #4

    Default Re: Can't import from 8.05 to 9.3i need help


    I created the tablespaces manually as advised without any problems, I
    added the ignore Y switch to the IMPORT and it seems to be going well,
    I also added the destroy N switch I assume that will prevent the export
    from killing anythign it doesn't like or already exists (like my
    tablespaces for example).

    Thanks for your help :) I didn't have much hair left to tear out, much
    appreciated.

    --
    Posted via [url]http://dbforums.com[/url]
    splashy Guest

Similar Threads

  1. dll import
    By Jason in forum ASP.NET Web Services
    Replies: 2
    Last Post: March 29th, 12:17 AM
  2. SWF import ID3.1
    By decorix29@adobeforums.com in forum Adobe Indesign Windows
    Replies: 5
    Last Post: June 27th, 11:15 AM
  3. hoq to import a gif
    By Ferdynandus webforumsuser@macromedia.com in forum Macromedia Freehand
    Replies: 0
    Last Post: November 25th, 09:33 AM
  4. No CDR Import?
    By Linda Rathgeber in forum Macromedia Fireworks
    Replies: 0
    Last Post: September 18th, 10:57 PM
  5. CSV import
    By Jwulff in forum PHP Development
    Replies: 0
    Last Post: July 21st, 05:42 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139