Re: How to copy JUST the structure of a tablespace?

From: Torben Jeppesen <torbenkj_at_post2.tele.dk>
Date: Sat, 27 Jun 1998 20:33:35 GMT
Message-ID: <359555bc.1247910@news.euroconnect.dk>

On 25 Jun 98 14:32:23 GMT, dolans_at_stripe.Colorado.EDU (Sean Dolan) wrote:

> In my last posting I was a little vague in my goals, so I thought I would attempt to explain again. All I need to do is take the structure of a current tablespace/schema (whatever it's called) and copy it to a new one. Is there an easy way to do this? The data is unimportant, just the structure, sequences, roles, etc.
>
>Thanks,
>Sean Dolan

Unfortunately you are still at bit vague on your goals.

A tablespace is a subset of the database an consists of some files. It can contain objects for several users.

A schema is the set of objects owned by one specific user.

I have no easy solution to export the definitions of the objetcs in a tablespace.

Copying the definitions for a schema is easy. Use the "exp" utility and export the user without exporting table data. Then import as the user who is going to receive the copy.

With regards
Torben Jeppesen Received on Sat Jun 27 1998 - 15:33:35 CDT