Re: HELP: Recreating or copying tablespaces in Oracle 8.1.7?
Date: Sun, 16 Mar 2003 05:36:59 GMT
Message-ID: <Xns9340645C9D3Cdbabobhotmailcom_at_204.127.204.17>
"Ana C. Dent" <anacedent_at_hotmail.com> wrote in news:Xns9336B346354F9SunnySD_at_68.6.19.6:
> Bob <bob_at_hotmail.com> wrote in
> news:95qf6vcloko3kdumq4gjnmc8v1g9ujb30g_at_4ax.com:
>
>> On Wed, 05 Mar 2003 00:49:46 GMT, "Ana C. Dent" >><anacedent_at_hotmail.com> wrote: >> >> >>>> >>> >>>Please do yourself & everyone else involved a big favor >>>and stop pretending that you know anything about Oracle. >>> >>>Go take a couple of days & read for the 1st time the >>>Oracle Concepts Manual. It is obvious you understand >>>little, if anything, about Oracle and internal components. >> >> Interesting, but the fact that you were unable to offer any >> constructive advice indicates to me that you are (perhaps) unable to >> answer or even understand the nature of the question.
>
> You are quiet correct.
> I did NOT understand your posting,
> because it was a convoluted mishmash of database related terms
> that made absolutely no sense in context of discussing an
> Oracle database. While this is a slight exageration I considered
> your original post similar to the following question.
>
> What is the best color of the rainbow;
> sandy, shrill, sour or soft?
>
> I'd conclude that a person who would ask the
> question above had little or no concept of
> exactly what was a rainbow. This is why I
> suggested that you try reading the Concepts Manual.
> After that you might be able to pose an intelligent
> question which actually might get an answer or two.
>
DITTO! Just so you understand where Ana is coming from.
>>>> allow me to copy existing tablespaces within the *same* >>>> global database.
There is no such thing as a "same global database" it is either a database or it's not. A database consists of a grouping of datafiles, some of those datafiles are represented inside of the database as tablespaces, others are not.
>>>> For example, we have 4 extents (Prod, Pilot, Demo >>>> and Test)
Ok here is where you really really go wrong. An extent refers to segment of an object that requires physical storage (tables and indexes), not to something like Prod, Pilot etc.
They might however represent schemas within a database, but not extents.
>>>> and I want to make duplicate copies of "Prod" within the same >>>> RDBMS. The answer is yes, but that is assuming they are schemas withing the database, but the method (imp/exp) would only apply in that case. In other cases the method would be different.
>>>> Is there a way to automatically recreate a second copy of "Prod", >>>> with the related IDX and TEMP tablespaces
Here you go into left field again. A TEMP tablespace is used in a database, but it isn't associated to that user, just used by that user. It can be shared by many users, although there are situations where you might want to have different temp tablespace for different users, but you don't need to duplicate it, you would just create a new one and assign it to that new user.
>>>> I am a newbie at this.
No kidding!
The suggestion to read the concept manual was not done to insult you, but was done so that you can have the basic knowledge required to actually ask the question that needs asked rather than something that has no answer since the question itself makes no sense at all.
Sorry if we have hurt your feelings, but you were the one who wrote the question not us. Received on Sun Mar 16 2003 - 06:36:59 CET