Hi,
have to granted resource to them , if so revoke,
and make quota 0 on another users tablespace

sharan
----- Original Message -----
From: "sribhashyam bhashyakar" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, August 30, 2002 4:43 PM
Subject: advice needed!!


> 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
>

Oracle LazyDBA home page