jsmithstl
Last Activity: Oct 29 '10, 08:57 AM
Joined: Jun 28 '07
Location:
-
can you post the description of each table. Are you trying to update the lotno_id column in both tables? Is lotno_id a primary key or foreign key in either table? -
Once you put the entries in your lsnrctl.ora file, did you stop and restart the listener?
lsnrctl stop
lsnrctl start
Once you've restarted the listener, do as Prabukrishnan suggested. Run the following from the command line and paste the output in here.
lsnrctl services
Also, can you paste the contents of your sqlnet.ora file as well?Leave a comment:
-
make sure your environment is setup correctly.
set your ORACLE_SID to the database you wish to connect to:
export ORACLE_SID=BSNL
rman
connect target /Leave a comment:
-
Can you put an example of what your want your output to look like? How big is your software.csv file? Do you have to write this in sh or is perl an option?Leave a comment:
-
I'm not sure I understand. It sounds like each column represents a week and there are 104 weeks but week 1 in table 2 compares to week 2 in table 1.
Can you do a describe of each table and post them?
What is it you are trying to accomplish? It sounds like a different table design might help. Are you able to change the design or do you have no choice but to use this design?Leave a comment:
-
Assuming the AMOUNT is a number column.....
SQL> select * from cumtemp;
ID AMOUNT
---------- ----------
1 100
2 150
3 170
4 200
5 200
6 240
7 280
8 343
9 354
10 390
...Leave a comment:
-
I've used "break on" since version 7. Are you using sqlplus or do you need to run this in a different query tool?Leave a comment:
-
Sorry... trying to get the output to look proper on this site. Hopefully, this will show you what the ouput should look like when you use the break statement.
OWNER TABLE_NAME
------------------------ -----------------------------
SYS AUDIT_ACTIONS
AW$AWCREATE
OLAP_OLEDB_MDPR OPVALS
PLAN_TABLE$
...Leave a comment:
-
just add a break statement.
--
-- without a break statement
--
select owner
,table_name
from all_tables
where owner in ('SYS','SYSTEM' )
order by owner
,table_name
OWNER TABLE_NAME
------------------------ -----------------------------
SYS AUDIT_ACTIONS
SYS ...Leave a comment:
-
What is your database characterset? If it's US7ASCII, it can't support those characters. If the characterset your using doesn't support those characters, oracle replaces them with and inverted ?. I would suggest using AL32UTF8 or UTF8. Also, make sure you set your NLS_LANG environment variable correctly. It should match the characterset the data you are inserting was created it. NLS_LANG tells the database what language you are sending it so...Leave a comment:
-
I would:
1. create an oracle directory.
2. put your flat file in that directory.
3. create an external table using the flat file.
4. use a MERGE INTO statement to update the table.
MERGE INTO allows you to update a row if it exists or insert the row if it doesn't. As of 10g, you can even delete rows using MERGE INTO.Leave a comment:
-
Check the NAMES.DEFAULT_D OMAIN in your sqlnet.ora file. If for instance in the sqlnet.ora file you have:
NAMES.DEFAULT_D OMAIN= corp.company.co m
Then your tnsnames.ora entry should look like:
stl_dr.corp.com pany.com = ...
Additionally, I'm pretty certain Oracle recommends you use SERVICE_NAME instead of SID in the tnsnames.ora entry for 9i and up.
If you'll go to the...Leave a comment:
-
Statistics have no bearing when OPTIMIZER = RULE Change your OPTIMIZER to COST or CHOOSE then Oracle will use the statistics gathered through the analyze command or better yet use the dbms_stats package.Leave a comment:
-
It depends....
SID as in ORACLE_SID does indeed = instance name as the link above states.
SID as in "associated with an oracle session or username", = session identifier.Leave a comment:
No activity results to display
Leave a comment: