Re: Import Question

On May 31, 2:27 am, Maxim Demenko <mdeme...@xxxxxxxxx> wrote:
ame...@xxxxxxx schrieb:



Hi,

This is supposed to be very simple, but it is not happening.

I exported a table. Big deal right? I want to import that table into
another database in which the tablespace the table originally existed
does not exist.

I am receiving ORA-00959 errors. I have tried importing as system, as
myself, with the ignore flag, without the ignore flag, using fromuser
& touser..........it just keeps failing.

IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'DATA_HOLDER_DATA' does not exist
Import terminated successfully with warnings.

Though it says successful, the table is nowhere to be found in
DBA_TABLES. We are on Oracle 8i.......

Any suggestions??

I assume, this question is related to your previous post regarding
nested tables.
Generally, you have two options by import to avoid ORA-00959:
a) Get ddl of your table, adjust it and create your table before import
in desired tablespace, then import with ignore=y
b) Create tablespace with same name as in the source database.
This apply to all tables which consists of more than 1 segments (hence
have multiple storage clauses, i.e. partitioned tables, tables with
LOB's, nested tables etc.)
Only simple heap tables which consists of 1 segment will be created in
default tablespace if original tablespace doesn't exist.

Best regards

Maxim

the reason is clear, you are getting this error because the tablespace
does not exist in the new database. just run the import with show=Y
option and from the logfile, extract the tablespace creation
script,create the tablespace manually and then run the import. It
should be successfull now :)

Sidhu

.

Relevant Pages

  • Re: How to rebuild Init file
    ... Well, the drive it was on crapped out, and upon replacment, my database wound't start, no init file. ... I found the control files and put those in the init, then based off the parms in an old alert file, I set those, the only thing I struggled with then were rollback segments, but I just created a new tablespace and new segments, and after it was running ok, re-created the originals, then blew away my temporary new one. ... SVRMGR> alter rollback segment rbs0 online; ... The tablespace datafile was there and online. ...
    (comp.databases.oracle.server)
  • Re: Begin... END; gives odd error:
    ... I am testing an Oracle interface layer, and created it as the System ... It doesn't matter if all this database stores is your grandmother's ... tablespace, a tablespace reserved for SYS and SYSTEM owned objects ... SQL> create user test identified by hokeypassword default tablespace ...
    (comp.databases.oracle.server)
  • Testing rman recovery from block corruption in an 11g ASM environment
    ... Testing database recoveries is a DBA responsibility. ... blocks in the database ASM throws some more wrinkles in the mix. ... environment like that dd is the tool of choice usually ... ... create a small tablespace in ASM ...
    (comp.databases.oracle.server)
  • impdp.exe problem
    ... we did new database like this: ... default temporary tablespace temp ... GRANT UNLIMITED TABLESPACE TO xxx; ...
    (comp.databases.oracle.tools)
  • Re: ORA-01654 Fix?
    ... The reason that "you are being told to create another tablespace" is ... that user segments should not be stored in the system tablespace. ... not familiar with administering an Oracle database. ...
    (comp.databases.oracle.server)