trouble importing OracleOCI definitions

cdrk823 · Post by **cdrk823** » Wed Jun 15, 2005 3:29 pm

Hi everyone,

I'm having some difficulty getting the list of our tables when I'm importing table definitions from Oracle. Actually, as of writing, I still haven't been able to get table definitions from Oracle.

I was able to do so, though, from our older databases.

Is there a way to filter out what tables to get from the database, instead of having to get the list of ALL tables? What could be the cause of this delay?

Sorry if this topic might have been discussed in another forum. I really haven't had much success in looking for the right ones.

-cedrick

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Jun 15, 2005 3:30 pm

I think you have the option of 'name contains'.

cdrk823 · Post by **cdrk823** » Thu Jun 16, 2005 7:49 am

Yup, but that only appears AFTER the table names are listed.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 16, 2005 9:29 pm

It's called "Filter" before the table names are listed. Sometimes "Advanced".

chulett · Post by **chulett** » Thu Jun 16, 2005 9:50 pm

ray.wurlod wrote:It's called "Filter" before the table names are listed. Sometimes "Advanced".

And unfortunately it doesn't exist in the OCI stages.

cdrk823 wrote:Is there a way to filter out what tables to get from the database, instead of having to get the list of ALL tables? What could be the cause of this delay?

What delay is that? What exactly is the problem you are having? The smallest subset of table names you can bring back is for a single schema. I just brought back a list of 635 tables from a schema and it took all of 18 seconds - and that's remote over VPN. Did you switch from the default of ALL OWNERS to a single owner before getting a list of the table names?

The 'Name Contains' box is just a mechanism to cull the list of names after you've pulled them from the database to make your selection process (possibly) easier.

cdrk823 · Post by **cdrk823** » Fri Jun 17, 2005 10:04 am

chulett wrote:
ray.wurlod wrote:It's called "Filter" before the table names are listed. Sometimes "Advanced".
And unfortunately it doesn't exist in the OCI stages.

cdrk823 wrote:Is there a way to filter out what tables to get from the database, instead of having to get the list of ALL tables? What could be the cause of this delay?
What delay is that? What exactly is the problem you are having? The smallest subset of table names you can bring back is for a single schema. I just brought back a list of 635 tables from a schema and it took all of 18 seconds - and that's remote over VPN. Did you switch from the default of ALL OWNERS to a single owner before getting a list of the table names?

The 'Name Contains' box is just a mechanism to cull the list of names after you've pulled them from the database to make your selection process (possibly) easier.

I simply can't pull the list of table names from our database to import as new table definitions. There really isn't any error messages, the list just wouldn't show up - it's just loading and loading.. (which is what my 'delay' is)

ds_developer · Post by **ds_developer** » Fri Jun 17, 2005 10:46 am

Exactly what Import | Table Definitions | choice are you using?

"Plug-in Meta Data Definitions" lets you pick the database, the schema, the specific table(s). That should allow it to load pretty fast.

John

cdrk823 · Post by **cdrk823** » Fri Jun 17, 2005 11:43 am

ds_developer wrote:Exactly what Import | Table Definitions | choice are you using?

"Plug-in Meta Data Definitions" lets you pick the database, the schema, the specific table(s). That should allow it to load pretty fast.

John

I am using that.

I just found out that this issue only happens for one specific owner 'SYSADM'. I've tried picking different owners and the list comes up pretty fast. Is this because of some restraints on permission?

chulett · Post by **chulett** » Fri Jun 17, 2005 1:10 pm

PeopleSoft by chance?

In a PeopleSoft instance, all application tables are owned by SYSADM - and that can be 20 or 30 thousand tables.

You must learn patience, Grasshopper.

cdrk823 · Post by **cdrk823** » Fri Jun 17, 2005 1:46 pm

chulett wrote:PeopleSoft by chance? In a PeopleSoft instance, all application tables are owned by SYSADM - and that can be 20 or 30 thousand tables.

You must learn patience, Grasshopper.

Interesting.. very interesting..

does it usually take hours?

But actually, our older database has a different owner for the application tables. So, maybe - just maybe, if we do this then we can see some improvement.

Thanks!