Re: Tablespace problem

From: Chuck <chuck_hamilton_at_yahoo.com>
Date: Thu, 6 Dec 2001 08:34:13 -0500
Message-ID: <9uns2n$9bacm$1@ID-85580.news.dfncis.de>

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

"adil" <aadil_at_loveable.com> wrote in message news:2f4ab398.0112060332.73bb61fa_at_posting.google.com...
> i took a dmp from 8.1.6 of user abc and trying to import it in user
> abc in 8.1.7
> which is linked with def tablespace. but when i view the user abc
> it shows linking with system tablespace. i have also given quota 0
> on system How do i connect it to def tablespace.

Import will try to place things into a tablespace on the destination database with the same name as the one that held the object on the source database. If it can't it will try to use the user's default tablespace. Your default tablespace on 817 was probably SYSTEM. Drop the user with the cascade option to clean up all the objects in SYSTEM. Recreate the user with the proper default tablespace. Grant quota on that tablespace to the user. Then reimport the user.

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBPA9z0mm5A4kkb4ZsEQIrTwCggTM0i0SdcxLdKG6RmhWNsnNhnDcAn1JP 43UtHStsrmsg028NyQlri/hm
=wtrX
-----END PGP SIGNATURE----- Received on Thu Dec 06 2001 - 07:34:13 CST