Removing Duplicate tables in same table space having same owner [message #70986] |
Fri, 23 August 2002 04:36 |
prashant
Messages: 122 Registered: September 2000
|
Senior Member |
|
|
hi,
I am working on Oracle 8i server. i had a database on MS Access 2000. I exported the data alongwith the structure into SQL server 2000, and from SQL Server 2000 to Oracle 8i server.
There were 42 tables in my database. Now when i execute a select query on any of the table, it says
table or object does not exists.
i then created a script file and executed on the server. the script file contained query to create all those 42 tables which i had exported.
now my database is showing 84 tables. each table is duplicated. all the tables have a name one with small letters (itemmaster) and one with caps on (ITEMMASTER). both have same table space name and same owner. i want to delete the one which was created using the export feature of sql server.
please help me out .....
Prashant Malik
|
|
|
|