How to record at SqlServer using Oracle

Hi friends How can i do for write data in SqlServer database using Oracle. Need I run the process in sqlserver or in Oracle ? What is necessary for it ? database link ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eriovaldo Andrietta INET

Re: Resource for index

pelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.or

Data Entry

Hi Friends, I would like to know what is Data Entry in Oracle environment. Is it a tool ? Is it a language ? What kind or resource or tool is it ? Tks Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eriovaldo Andrietta INET

Re: STATSPACK

ifornia-- Mailing list and web hosting services > ----- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the messa

Re: STATSPACK

Title: RE: STATSPACK   Friends :   What does it mean : STATSPACK ?   Regards   Eriovaldo       - Original Message - From: Koivu, Lisa To: Multiple recipients of list ORACLE-L Sent: Monday, December 09, 2002 3:24 PM Subject: RE: STATSPACK Wow that does sound w

Monitoring Database by Unix

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Snapshots - Doubt about

o do it ? > Why refresh with rowid is not recomended ? > How to do when master table doesn't have a PK ? > > Regards > > Eriovaldo > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Eriovaldo Andrietta > INET: [EMAIL

Snapshots - Doubt about

Friends I would like to know about snapshots. Can I create a index on snapshot ? How to do it ? Why refresh with rowid is not recomended ? How to do when master table doesn't have a PK ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erio

Re: Scripts for creating Tables/schema's

Friend :   You can use the option INDEXFILE of imp program.   INDEXFILE=c:\your_name.txt   Ity will generate the script.   I am not sure if it runs with exp, may be ...   I had used with imp.   Regards   Eriovaldo       - Original Message - From: Santosh Varma To: Multi

Script for Import 29000000 lines in background and to create index.

that : 1.) imp user/passwd file=file.dmp fromuser=user1 touser=user2 rows=y log=log1; 2.) create index ind1 on table1 (col1, col2) tablespace tbs1; My doubt is : How to write a shell script using nohup and & and that the second item wait the first finish. Regards Eriovaldo Andrietta [EMAIL P

How to do for point at the first line of openned cursor

Hi Friends Is there any way to point at the first line of openned cursor ? For example : After apply the for ... loop at the finished i would like to set the first line , but "i don't want to open it again" Regards Eriovaldo Andrietta [EMAIL PROTECTED] -- Please see the of

Re: DB link problem

gt; the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

How to learn XML ?

Hi friends : How can i do for learn XML ? Does anyone know some good site that teaches it for us ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Data Centers

analyzed. Regards Eriovaldo [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

MTS and Dedicated Server

Dedicated ? I think that i need jut to take out the parameters with mts_ at the begin and reestart the instance , right ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services

Dedicated Server versus Shared Server

Hi friends : What is the diference between The instance in dedicated mode and shared mode ? Can I to change the mode from one to other ? What is the best way ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL

Re: I need to change the instance name (to Dennis)

t; Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California--

Re: I need to change the instance name (to Dennis)

; > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Kimberly Smith > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access

Re: I need to change the instance name

LOPER. > > I know how to change the database name , but not the instance name .. > > Any idea ? > > Regards > > Eriovaldo > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Eriovaldo Andrietta > INET: [EMAIL PRO

I need to change the instance name

Friends : I need to change the instance name. For example it is : DEVELOP and I need to put DEVELOPER. I know how to change the database name , but not the instance name .. Any idea ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo

Re: sqlldr

. We have a NT server with oracle 7.3.4 and 8.1.6 installed in two homes and there are no problems.   Yechiel Adar Mehish - Original Message - From: Eriovaldo Andrietta To: Multiple recipients of list ORACLE-L Sent: Sunday, April 28, 2002 2:13

Re: sqlldr

  HI Yechiel :   How can i to install two versions of Oracle in the same server , like :   Oracle 8i and Oracle 9i, in oracle_home different.   Is it possible ?   Regards   Eriovaldo     - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L

Re: Patch Install (8.1.7.3) and oraInventory

ne containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTE

Re: char vs. varchar2

DY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta IN

Describe Command is Slow

HI Friends : I am executing DESCRIBE and it is slow. The indicator of tuning of data dictionary is around 0,9. What is happening ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network

Downgrade Oracle 8.1.7 Enterprise to 8.1.7 Standard

e the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

EDI Translator

Hi Friends : Does anyone use EDI Translator ? Is it a toool of Oracle's ERP ? Does anyone use translation from EDIFACT using pl/sql ? What resource is used for it ? Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta

Re: Planning Test Backup/Recovery

Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > -------- > To REMO

Nested Table

? []s Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Select in TABLE OF

Hi Friends :   I have the follow situation :   I have a table and i did select getting data. After it i used the data in a cursor and put it in a type variable TABLE OF varchar(4000) , for example .   Now, I would like to do select in this table of and pass it as parameter out refcursor .   I

Oracle Advanced Queuing

HI Friends :   What is the basic function of Oracle Advanced Queuing ? How does it work ?   Regards Eriovaldo