Re: Import Question

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 02 Jun 2007 20:41:38 +0200
Message-ID: <f3sdl0$fhi$1@news3.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Brian Peasland wrote:
> amerar_at_iwc.net wrote:

>> 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??
>>

>
> If the tablespace does not exist, the table should get created in the
> user's default tablespace. But you can precreate the table in any
> tablespace you want and then import with IGNORE=Y. To get the CREATE
> TABLE command, use SHOW=Y to see the dump file's DDL statements. Also
> use the SPOOL parameter with SHOW=Y to write the output to a text file
> which you can then edit into your CREATE TABLE statement.
>
>
> HTH,
> Brian
>

It will be created in the users default tablespace, unless there are large objects involved - these cannot be relocated. My guess is, this is the case, but it's just a guess.

Any logging, and screenscrapes of actual sessions are most helpful

• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGYbniLw8L4IAs830RAi4aAJ0dxi7vKbpXettB76C475WadrsQ8ACfZCq6 xrb+Whf/b/J7pcp/CSB41fQ=
=LG7+
-----END PGP SIGNATURE----- Received on Sat Jun 02 2007 - 13:41:38 CDT