Error while importing table metadata by using plugin

mini · Post by **mini** » Thu Jul 09, 2009 4:22 am

When I try to import a table metadata by importing through plugin metadata definitions I get ann error saying No columns to be imported.
but the table contains columns and data when viewed through backend.
Also,if I fill in the column names manuallyand try and vuew data with the database stage I can successfully view th table data.
This error is occuring for all tables in the database & for both parallel and server jobs.
The backend database is oracle.

Anyone have any insight on how to fix this.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 09, 2009 4:17 pm

Do you have SELECT privilege to the pertinent system tables in which the table and column metadata are stored?

mini · Post by **mini** » Fri Jul 10, 2009 12:01 am

Yes,we have select update and delete previliges on the table

ray.wurlod · Post by **ray.wurlod** » Fri Jul 10, 2009 1:27 am

Not on the table itself, but on the SYSTEM TABLES where the table and column definitions are stored. Check with your DBA.