I will try to answer your questions within your post. I do use Oracle and VFP works great with it.

>Do you have any experience with a VFP to Oracle implementation?
>
>If not, do you have anyone (in your circle of email friends) that does?
>
>
>----------------------------------------------------------------------
>
>
>I have the following questions:
>
>I'm looking for a "step-by-step" guide to upsizing VFP6 tables to Oracle.

To my knowledge, one does not exist.

>I know about the upsize wizard, have used it, etc.
>
>But I'm looking for (hopefully) some guides to setting up the Oracle side
>and what pitfalls, workarounds, etc are available.
>
>for example:
>
>Is it best to 1st migrate only the Fox db schema to Oracle, then set user
>permissions, then migrate the data?

Have toe Oracle DBA set up a specific user ID for your schema. This should be a name that reflects the app. e.g., I am doing an app here for permits, so my schema name [user ID] is PERMITS. I would then create Roles that have been granted permissions based on user need. I have 2 basic roles: PERMITS_READ, PERMITS_UPDATE. The PERMITS_READ role only gets the select privileges on the PERMITS tables. PERMITS_UPDATE gets select, insert, update, delete privileges on the PERMITS tables. Then, as users are added, all I have to do is grant the role to them. As you add tables, you grant privileges on those tables to the roles.

As long as the tables exist, it does not matter when you migrate the data.

>What defaults should I except?

I don't understand this question.

>How should I allocate space?

I you have an existing database, the amount of space it is consuming now will be about the same space required in Oracle. You of course want to allocate for growth. Usually I have a tablespace for my data, a space for the indexes, a temp space and a rollback space. This only optimizes performance if these spaces are on different drives. The Oracle documents for DBAs have a fair amount of info on optimizing.

The later releases of Oracle [7.x on] allow you to increase space allocations if you start to run out. Plus our DBA [if you plan ahead] created a new tablespace for me when I started our PERMITS app.

>Should I use remote views or Sql-pass-thru?

Use both. I use remote views for updatable data. I use combinations of both views and SPT for general retrievals that I do not plan to update. I take advantage of VFP features whenever possible, and remote views are very easy to deal with.

>How do I get a vfp "seek" to work?

If you are referring to using this on a view or cursor, you can INDEX ON SOMEFIELD TAG MYTAG as long as the buffering is record. When the view or cursor is closed, the CDX files is deleted as well as the temporary cursor file.

I also have an article in the KB on connecting VFP to Oracle. See purple book, Articles, Client/Server.

As you progress in your project, go ahead and post your questions here. Try to limit each post to a single question and be as specific as possible. There is a really good document here that was initiated by Erik Moore with tips and suggestion of creating a post to get the best responses and solutions. To see it, click Reply at the bottom of this message. At the bottom of the reply form, you will see a link called Rules of conduct... In that document there is an Etiquette section. I was able to generally post a reply to all your questions, however, if someone could only answer 1 of your questions, they may have refrained because they could not reply to the others.

Good luck!