trouble importing OracleOCI definitions
Moderators: chulett, rschirm, roy
trouble importing OracleOCI definitions
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
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
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
And unfortunately it doesn't exist in the OCI stages.ray.wurlod wrote:It's called "Filter" before the table names are listed. Sometimes "Advanced".
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?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?
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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)chulett wrote:And unfortunately it doesn't exist in the OCI stages.ray.wurlod wrote:It's called "Filter" before the table names are listed. Sometimes "Advanced".
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?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?
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.
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
I am using that.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 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 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!