Hello, DBAs:
I'm doing data migration (say from 3.1 database application to 4.1) using SQL script on Oracle 8i. Here are something I can't understand.
After I insert all the data from old database, the last step I need to build a new intermediate table-A (with the PK on several tables) which was
Not seen the message I posted, here I'm again:
Hello, DBAs:
I'm doing data migration (say from 3.1 database application to 4.1) using SQL script on Oracle 8i. Here are something I can't understand.
After I insert all the data from old database, the last step I need to build a new intermediate
You can increase the length by:
" set serveroutput on size 100 "
But this is the maximum you can go.
HTH
Helen
"Cale, Rick T (Richard)" [EMAIL PROTECTED] wrote:
This is a restriction to using dbms_output that maximum length is 255.From MetaLinkThis is a restriction of the package
Hello, All:I can't find any reference about FTP syntax in UNIX shell script. Here is my problem and ask for help:
On one server, we have couple of SID (this client setup can't be changed). Then in the ( Bourne Shell ) profile, we have for each SID:
TBAE_FTP_AR_DSN='DS1B.X1.TIDE.X'export
Thanks, Butthe thing is that the file name for GET need to be in ( ' ), otherwise, (the way that env setup), it will add current path to the file name.
when I try get ${ORACLE_SID}_FTP_AR_DSN , it returns error as:
"Invalid data set name "/export/home/vwif/TBAE/FTP_DIRECTORY/IMP_AR_W.DAT".
Hello, all:
I'm import data from schema1.table1 (ASSET_NUM,COMPANY_ID,CONSOLI_ID
) to schema2.table2 (ASSET_NUM,COMPANY_ID,CONSOLI_ID
)using SQL script on Oracle 8i. The situation is like this:
In schema1.table1, it does not has a Primary Key and Table1.ASSET_NUM has duplicated records while
Hi,
I want to insert a string like 'AM University' but has problem with '' I want the database exact AM University. But it always ask me new or old value because of symbol '' how could I deal with that. Thanks.
HLDo You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo!
Hi ALL:
Anybody has any luck to install oracle 8.1.7 on Solaris 8. I installed 8.1.5 on same OS without any problem. When I run dbassist , I got ORA-03113 error message. Actually It happened when you execute the command:
startup nomount pfile="/u01/app/oracle/admin/DEV/pfile/initDEV.ora"
I
Hi Ray:
Thanks. How can I get information about Doc ID: 17613.1 . Also there are banches of semaphore related parameters. Any guidance to do that?
Ray Stell [EMAIL PROTECTED] wrote:
On Thu, Jul 12, 2001 at 02:45:22AM -0800, Helen rwulfjeq wrote: Hi ALL: Anybody has any luck to install oracle
I tried this but didn't work. Thank you so much.
H.L.
Jon Walthour [EMAIL PROTECTED] wrote:
Helen:Try reducing your SHMMAX kernel parameter to under 4GB and seeif that works.--Jon Walthour, OCDBAOracle DBAComputer HorizonsCincinnati, Ohio--- Original Message ---From: Helen rwulfjeq <[EM
Hi ALL
Thank you for all of your responses. I made it working now. What I did is to change couple of semaphone parameters by modifying /etc/system file.
Thank you again. I will take a rest now.
L.H.
Helen rwulfjeq [EMAIL PROTECTED] wrote:
I tried this but didn't work. Thank you so much.
H.L
Hello, DBAs:
I had a user level export from a 8.1.7 database and then import to my 8.0.5 local database. But all the triggers (except one) belongto that userare missing. I had done the same export from 8.1.6 couple of times before, never has a problem. Does 8.1.7 cause the missing triggers?
If so,
(LTRIM(V$DATABASE.NAME))||'_'||C_REPORT_ID.REP_FILE_NAME, 30),NAME,ADDRESS,FLOOR,ROOMFROM VW.C_EXPORT_CYCLE, C_REPORT_ID, V$DATABASEWHERE C_REPORT_ID.REPORT_ID = C_EXPORT_CYCLE.REPORT_ID;
spool off
-Original Message-From: Helen rwulfjeq [mailto:[EMAIL PROTECTED]]Sent: Wednesday, 27 June 2001
Yahoo nor its licensors are responsible for any damages caused by your decision to do so.
Powered by:Does your computer have a virus?Get Norton AntiVirus find out!
Venkata Apparao N [EMAIL PROTECTED] wrote:
'Helen rwulfjeq' wrote:- - Hi ,- - - - Oracle database system uses very compli
.
Powered by:Does your computer have a virus?Get Norton AntiVirus find out!
Venkata Apparao N [EMAIL PROTECTED] wrote:
'Helen rwulfjeq' wrote:- - Hi Guru:- - We have a window's machine runing oracle database. Originally the database uses static IP address. Everything is fine. Now we change
Hi Guru:
We have a window's machine runing oracle database. Originally the database uses static IP address. Everything is fine. Now we change the network config to use DHCP server to assign IPaddress dynamically. We have the error message. Database is up but we can't use svrmgrl, sqlplus and
Hi ,
Oracle database system uses very complicated lock/unlock design for readlock,writelock and row/recordlock etc. Does anyone know lock/unlock is implemented both client like sqlplus and server side or just on server side or just client side. For instance, one user using sqlplus access
Hello,
I have a file to contain info about the reports detailed info (stored in a temp table in the DB) we created every night. Such as: report ID, report_name... However, sometimes there is no report generated overnight. In this case, the temp table would be empty. But this file will still spool
Try:
SICK_ACCRUAL POSITION(569:583) integer external(14),
VAC_ACCRUAL POSITION(585:599) integer external(14)
Helen
"Johnston, Steve" [EMAIL PROTECTED] wrote:
Thanks in advance for help, been lurking for a couple of weeks.I am using sqlldr73.exe to load a text file into an oracle 7.3.2.1.1
Hello, Being not a UNIX expert, I'm write unix SQL scripts to generate report. But have difficulty to split the file according the report ID. I'm wondering IF UNIX (sh script) can split a big text file into several different files according to a certain field (from posX to posY), when that field
seven years ago', 'seven') -1) from dual
SUBSTR('FOURSCO---Four score and
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-----Original Message-From: Helen rwulfjeq [mailto:[EMAIL PROTECTED]]Sent: Monday, June 11, 2001 4:07 PMTo: Multiple recipients of list
will this work?
RENAME TABLE_NAME TO table_name_2;
create table TABLE_NAME(column_name_you_want...)as select * from table_name_2;COMMIT;
DROP TABLE table_name_2;COMMIT;
HTH
"Deshpande, Kirti" [EMAIL PROTECTED] wrote:
Hi Raj,1. There is a way to do it. And Mr. Steve A. has some good info about
Hello:
Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today.
I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5.I have to install 8.0.6.(new one) Then I
Hello DBAs:
Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today.
I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5. I have to install 8.0.6.(new one) Then
Great! That works too.
Now I can do it (modify the data) from either Shell script or control file.
Thanks for all the input.
Saj Raza [EMAIL PROTECTED] wrote:
Try something like the lines below, as 9 is the ASCII code for a TAB :load datainfile *INTO TABLE experiment_with_tab_delimiterFIELDS
25 matches
Mail list logo
