logs archiveIRC Archive / Freenode / #oracle / 2010 / May / 28 / 1
Xgc
Ramen: Use CASE or similar.
Ramen: A logical expression is not a selectable value in many databases.
Ramen: SELECT CASE WHEN '0' < 'A' THEN 1 ELSE 0 END FROM dual;
dballester
good night
Ramen
Thanks Xgc
is select * from table join a on (a.x=table.x, a.y=table.y) legal?
zasz
RJarett:
respond
plz
KeiKurono
morning
baumhouse
lamest channel ever seen!
mastro
I'd like to use datapump to transfer throw network some schema, can you tell me if I got the procedure right?
(both source and target database are Oracle 10g)
1. create user 'john' on target database and give him a tablespace 'john_ts'
2. create a directory
3. impdp sys/secret DIRECTORY=dmpdir NETWORK_LINK=old_john remap_schema=old_john:john
I forgot a step
2.5. create database link old_john connect to old_john identified by secret using '???my link here in a form I don't know???';
my questions: a) how do I define the link to the other database? b) can I use sys user to import the data? c) will the data be imported in the tablespace I specified? d) will indexes, triggers and procedure for user "john" be also imported? e) did I got the step right?
thanks
Ok i got how to create the database link
can you help me with the other questions?
dsdel
a) google: oracle dblink
b) import or impdp?
c) therefor you transfer data you should read the documentations to the tool you're using
mastro
b) yes impdb
dsdel,
c) i read it but I did not find this information
dsdel, I get this error: http://pastebin.com/s4YBx6WV
         

dsdel
I would estimate that the database isn't started :D
if you've read the documentation a) should be clear - further c and d
mastro
dsdel, which one? the target or the source? and ... i can connect to both of them just fine with sqlplus from the target oracle
dsdel, how can I "debug" the issue? may be a way to test the database link?
dsdel
do a select above the database link
mastro
dsdel, hum, what do you mean? select * from mylink ?
dsdel, it's not a table.. so I don't really know how to do it
SELECT * FROM emp@foo
dsdel, ok I think i got the issue
dsdel, the ORACLE_SID wasn't correctly set... Now I think I have issue with the datalink: i created the database link with sys and then created a symbolic link for the user I want to use the link... it doesn't work and I cant drop it either :) (hard to be a newbie)
dsdel, I can see the synonym here: select * from synonyms where sname like '%OWN%'; but I can't drop it nor with sys (myUser.synonymName) nor with the myUser
dsdel, ORA-01434
dsdel, ah.. ok solved this.. the owner was "sys"
TheBonsai
m00
can i GRANT CREATE TABLE to another user for my schema?
(or DROP)
ยน
b_52light
hi
ppl is it possible to have xmlelement with dynamic name
?
XMLELEMENT ("select 1 from dual",mot_cle )
usn_work
good CEDT afternoon
Xgc
b_52light: See: EVALNAME ... With Oracle 10gR2, when using Oracle XMLELEMENT, the value of the element could be an expression or the name of the element.
b_52light: See these examples: http://www.dba-oracle.com/t_oracle_xmlelement.htm
b_52light
Xgc: thanks mate
Xgc: :( i got an older 10g version ...
mastro
[WEBLOGIC] is there a way to set some java properties common to every element of the cluster?
sorry, of "A" cluster
R4md4c
Hello
Is this channel for oracle in windows?
Trengo
for everything oracle related
R4md4c
when i try to export my schema it says tns:protocol adapter error oracle 10g
and i can connect using sqlplus normally
usn_work
please copy&paste the export command
R4md4c
C:\Documents and Settings\SAYED-ALI>exp sayed/sayed file=c:\sayed.dmp
Export: Release 10.1.0.4.2 - Production on Fri May 28 16:54:05 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
EXP-00056: ORACLE error 12560 encountered
ORA-12560: TNS:protocol adapter error
EXP-00000: Export terminated unsuccessfully
will it be ok if i can uninstall oracle 10g then install from the beginning ?
usn_work
R4md4c, and your sqlplus connect?
reinstalling because of that is bullsh.....
R4md4c
usn_work: yes
usn_work
please copy&paste your sqlplus connect that works
R4md4c
I just start the sqlplus from the start menu then insert the username and password then it connects after that
usn_work
try it on command line
sqlplus sayed/sayed
what does it tell you?
         

R4md4c
Error: tns:protocol adapter error
usn_work
you see?
R4md4c
Ah i forget that i also installed oracle developer suite if that has an importance
usn_work
you have to set ORACLE_HOME and ORACLE_SID prior to the use of command line tools
R4md4c
how is that?
usn_work
google for it
R4md4c
here is the complete error :C:\Documents and Settings\SAYED-ALI>sqlplus sayed/sayed
SQL*Plus: Release 10.1.0.4.2 - Production on Fri May 28 17:31:52 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
usn_work
We know where the error comes from, no use for the full paste
now YOU have to do something for the resolution
R4md4c
ok do i set the ORACLE_HOME to the oracle directory not devsuitehome right?
usn_work
yes
The SID as well *SCNR*
R4md4c
The sqlplus command now works and now i've done the export command
usn_work
my bank account is .... ;)
teite
RMAN-04005: error from target database: ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_BACKUP_RESTORE","PL/SQL MPCODE","BAMIMA: Bam Buffer")
thats a nice error message, the BAM buffer ;)
usn_work
cool
teite
hmm flush shared pool didnt help
R4md4c
but there is another error while connecting to the form builder while using the username and password it says TBS:listener does not currently know of service requested in connect descriptor
and i modified the tnsnames file in the devsuithome folder
teite
usn_work: recompiling invalid packages helped
Ramen
can I do something like .... select * from tableA Join tableB ON (tableA.x=tableB.x AND tableA.y = tableB.y) ??
R4md4c
is there a way that i can tell oracle to use tnsname of devsuitehome instead of oracle directory?
Ramen
would a Left/Right join offer better performance than join?
usn_work
no, it's just syntax
aboudreault
hi. For a test purpose, I'd would like to set the password of a user to EXPIRED.
emm... if fact I'd like to get the error ORA-28002: password is expiring. Trying to force this for a user.
avaia
aboudreault: alter user <user> password expire;
aboudreault
avaia, no, this will throw ORA-28001.
ho, I think I've found something.... trying...
avaia
create a profile with a short lifetime, apply the profile to the user
aboudreault
avaia, yeah, trying to set a lifetime of 10 and a grace time of 15
avaia, currently the expiry_date is: 07-JUN-10. How could I change it to .. tomorrow ie?
I changed the user profile..... and tried to set a new password with the "password" instruction, but the date didn't change
matrix
hello
How to view data in Oracle dump file?
teite
strings xyz.dmp :p
« prev next »