Re: exp /imp

From: David Shaffer <shafferd_at_uswest.net>
Date: 2000/04/30
Message-ID: <390C4EF8.D14E3A07@uswest.net>#1/1

> You can only have table conflicts if a user tries to create two tables
> with the same name. If two users have tables with the same name you do
> not have a conflict because the tables are uniquely identified by
> preceeding it with the owner (owner.tablename). Putting tables in
> different tablespaces will not help resolve any of these conflicts. So
> I'm not quite sure what you meant about the above paragraph.

i was getting import errors when two separate users were importing the same table into 'users'. if the 1st user imported the table, the table had to be dropped before the 2nd could import. if i..
> select owner, table_name from user_tables;
.. it will show the current user as the owner.. ???

btw.. the alter/revoke method worked for getting the tables into the tablespace created for each user.. thanks Received on Sun Apr 30 2000 - 00:00:00 CDT