Re: advice needed!!

Re: advice needed!!

 

  

HI ,
thank you all for ur prompt replies.Ur advice's were very helpful.

regards,

bhashyakar


>From: Stephen J de Vries <[Email Address Removed] [Email Address Removed] Re: advice needed!!
>Date: Fri, 30 Aug 2002 07:56:24 -0400
>
>The tablespace where the data went is where it came from (to create the
>dump file)...
>
>If you want to create them elsewhere, perform a SHOW=Y capturing the DDL,
>modify the DDL
>with the correct tablespace, and run the DDL. Then run the import with
>IGNORE=Y...
>
>Steve
>
>On Fri, 30 Aug 2002 16:43:02 +0530 "sribhashyam bhashyakar"
><[Email Address Removed] writes:
> > hi gurus,
> > i have a problem and i need ur advice to overcome it.I have 3 users
> > who have
> > 3 different tablespaces assigned to them.when i perform an import of
> > a dump
> > file into a particular user,the import takes place but all the data
> > goes
> > into one particular tablespace,though this is not the assigned one
> > to that
> > particular user,due to this the datafile has become very large.I
> > have cross
> > checked and find that each user has a different tablespace
> > assigned,but
> > still all the data goes to a particular tablespace only.Can anyone
> > help me
> > overcome this problem,ie each user's data should go into their
> > assigned
> > tablespace(datafile)only.
> > My database is 8.1.6 RELEASE 2 on WindowsNT.Thanks in advance.
> >
> > regards,
> > bhashyakar
> >
> >
> >
> > _________________________________________________________________
> > MSN Photos is the easiest way to share and print your photos:
> > http://photos.msn.com/support/worldwide.aspx
> >
> >
> > --------
> > Oracle documentation is here:
> > http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to
> > oracledba-[Email Address Removed] > To subscribe: send a blank email to
> > oracledba-[Email Address Removed] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> >
> >




_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com

Oracle LazyDBA home page