SQL Help

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 13 Aug 2002 11:13:29 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7027F91F8@lnewton.leeds.lfs.co.uk>

Jim,

login to the user you want to export in the prod database and "select * from user_ts_quotas;". This will show you how many bytes have been used in each tablespace to which the user has quota granted.

Now create tablespaces in the test database, create your 'develop' user and give quota on the tablespaces, then do the import into develop.

Cheers,
Norman.

PS. select * from dba_ts_quotas_at_prod will show you the space used (and quotas allowed) on all tablespaces for all users :o)

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Joe Philip [mailto:joe.philip_at_verizon.net] Posted At: Monday, August 12, 2002 9:04 PM Posted To: server
Conversation: SQL Help
Subject: Re: SQL Help

I guess I have to reformat the question:

<SNIP> Received on Tue Aug 13 2002 - 05:13:29 CDT