Re: oracle 7.3 :oraview error 4204 table or view does not exist....

Hi Michel !!!!

i think :

Never make an Oracle table with Ms Tools Or other Desktop Databases as (Access, Paradox), you must use the syntax DDL to create a table from SQLPLUS of ORACLE.

3 Steps To migrate Access Table To Oracle Table (clasic mode):

  1.- Create an Oracle table from sqlplus using DDL sintax :

        Ex:
                drop table sales;
                create table sales
                (
                        id_sales varchar2(4) ,
                        etc
                );

   2.- Migrate Acces Table to csv File : ( FIelds separator By ";").

   3.- Use (SQLLOADER) Sqlldr of Oracle to migrate (Csv File To Oracle table)

• see the (pdf Acrobat) Oracle Administration, to learn the sqlldr syntax.

If you make a table from other tool as Paradox or Access, Error this tools write incorrectly the table into DBA repository.

Michael Clay Andersen escribió en mensaje ...
>Hi
>Im VERY new to oracle, and im having a little problem here....
>
>I've got a database running on oracle, with the table named sales.
>I can import it in access 7.0, and see what's in it, but i get the (subj)
>error when i'm importing it to excell....
>
>Does any1 have a clue, what to do, to make this work??
>
>the table, is imported to oracle, from a ms database, and from that
>database, there's no problems..
>
>Please...anyone??
>
>Yours Sincerely
>Michael C.
>
>
Received on Fri Oct 02 1998 - 06:46:59 CDT