logs archiveIRC Archive / Freenode / #oracle / 2010 / March / 29 / 1
solar_sea
alright, I'll try to get it working with dbms_redef. Still, I'm puzzled why this does not work, the execute immediate at @8 hasn't failed
RJarett
you arent committing, you are destroying your table structures and messing up your transaction by being in a plsql block and changing ddl right after a dml.
you arent returning out of your blocks
just everything about this is destructive and potentially table data destroying
and your logic is flawed on your if.
hey if i have rows, add another column thats bigger, take the old column and null it, and then move the data from the old column to the new one. then totally wipe out and fu*k up my old data even though the new data isnt committed. Then no matter what grow the old column, and then copy the old data from the new column back to the modified new column, and drop the new column even though its data wasnt committed.
really doesnt make alot of sense to me
because the end goal is just to modify cas2id to varchar2(128)
so why didnt you just do that in the first place?
while data still was in it
solar_sea
because I can't modify a column while it has data in it
Let me run just the modify statement and get the ora-code ...
RJarett
ya sure about that?
if duke wins this game and loses the next i win my works bracket
solar_sea
alright, I was totally wrong. our db comparison tool reported an nvarchar2 column as varchar2, which lead to column must be empty .. and etc. when i change either of those to the same type, but with different size it works without any of my addition crap.
RJarett
yeah dont use idiot apps
that an embarcadero app?
or quest?
solar_sea
worse, a internal piece of code initially written in C before several years, then ported to java & jdbc..
RJarett
why not just use dbms_metadata?
solar_sea
because we have to support sql server as well. as far as I know it's done using jdbc's databasemetadata & additional proprietary queries for each supported db vendor
         

RJarett
thats is so terrible.
solar_sea
tell me about it :)
davo
hi all. i'm trying to add a foreign key contraint to a table and getting this error message: "ORA-02275: such a referential constraint already exists in the table" yet when i try to drop the constraint in order to add it again i get "ORA-02443: Cannot drop constraint - nonexistent constraint". any ideas on what i am doing wrong? thanks in advance.
KeiKurono
morning
b\oracle
hello
ziga^work
Hi, does anyone has some experience with apex?
I got a problem with changing the apex applications, I change dem but it takes affect about an hour later
I think there is a commit missing?
somebody can help me?
Hi is someone online?
I need help with Oracle ApEx
Trengo
too early, the americans are still asleep
ziga^work
Hmm i see but i have to try it anyway to solve my problem as far as posible ^^
Trengo
google?
ziga^work
I have tried google, oracle forums and the german oracle community but i can't find a thing about my problem
cofeineSunshine
so, you could post a problem here allready
ziga^work
I posted it 2 hours ago but I will post it again
I work with ApEx 3.2.0.00.27 on Oracle10g Database
and the userinterface and everything works fine
but if i change something on my pages in the application builder the change take affect after one hour
so if i want to create a button i have to add it in the application builder and it stay there, but if i run the application i can't see it
I think there is a missing commit oder maybe something else, i don't know
KeiKurono
i translated from oracle to postgres via sqlFairy.. but it seems to miss some foreign keys constraint..?
RJarett
we really dont care
this isnt #postgres
not #sqlfairy
DiscordianUK
Interesting
RJarett
theres plenty of better migration apps out there if you cant recode your stuff yourself
DiscordianUK
It's one I've never heard of, sounds a little 'gay'
KeiKurono
the banner is a little gay indeed, but very funny
so, can you suggest me a better open source alternative if you know some
i'll try this ora2pg, even if i don't know nothing about perl
RJarett
www.google.com/?query=sqlplus
KeiKurono
sqlplus ?
         

RJarett
how large of a db? and how many objects?
stoick
if anyone has experience with overlapping date ranges: http://stackoverflow.com/questions/2538648/automatic-adjusting-range-table
lio_013
hello everybody
can i run an oracle application which use jinitiator on linux
i searched alot but i couldnot find a way
RJarett
http://forums.oracle.com/forums/thread.jspa?threadID=491166
edit the JDK plugin params
or use vmware or crossover (commercial version of wine)
lio_013
i dont use jdk i use sun java plugin
RJarett
same thing dude
lio_013
do i have to make any thing in the server
fitzgerald
SELECT e1.employee_name FROM employee AS e1
why it's wrong?
any help?:'(
RJarett
remove the as
fitzgerald
it works! thx:)
parigaudi
hi
i have access to an oracle server on which i'm supposed to create a new database with a schema based on an old one but modified
what free tools (preferably open source or java based) could give me a dump of the table structure (without data) of the old database?
RJarett
sqlplus
dbms_metadata
dont be an idiot and think a point and click tool is faster than whats given to you in the db
expdp
parigaudi
ok thx
the sqlplus package i downloaded ("sql plus instant client") contains two executables: adrci and gegezi.
is that even the right package i downloaded?
(sorry, i'm a total n00b at oracle)
RJarett
you have a database installed
you have sqlplus already
parigaudi
i don't have a database installed on my machine here
i have tcp access to a remote oracle server
RJarett
then ssh to the server
where will the new db be?
your desktop or the other system
parigaudi
i don't have ssh access, only access to 1521
the other db will be on the same server.
RJarett
the other db will be on the remote server
which you dont have full access to?
parigaudi
do i need ssh access to even create a database?
isn't it possible to do that with an sql client?
RJarett
no
is the remote server *nix?
or windows
parigaudi
there's no "CREATE DATABASE" sql command in oracle?
*nix
RJarett
you wouldnt be able to pull off a proper "create database" command
plus you cant do it remote
parigaudi
ok
well, then the guy who gave me that 1521 access will have to issue that create db command himself locally
but for that he'll need the database schema from me
RJarett
he will need to run DBCA db creation assistant
oracle isnt mysql
its a little more complex
parigaudi
yeah he knows oracle stuff, i don't
RJarett
then he will know how to move the structure over in a few seconds
parigaudi
it's not just moving the structure, but modifying quite a bit of it
RJarett
yeah a newb who doesnt know oracle modifying data structures.
sounds like winning combination for performance and reliability
parigaudi
oracle newb, not database newb
RJarett
same thing in my book
parigaudi
my original question was and still is: how do i get a dump of that db structure (remotely, not via ssh)
RJarett
i told you multiple ways
parigaudi
you told me 3 progs or ways, i installed a client, and thereupon my question was if that's even the right client
from then on, we completely derived to a different subject (the creation of the db) which has nothing to do with the dump
so is one of the two adrci or genezi from the "SQL PLUS instant client" package the right client prog?
RJarett
if you see a sqlplus.exe you have what you need to dump the sql definitions of the objects
you need basic and that
instantclient-basic-win32
instantclient-sqlplus-win32
parigaudi
no sqlplus in there. hmm. well maybe "instant client" was the wrong package then. the two i mentioned are the only executables in there, other than that there are only jars and so's in there.
ok
i tried the linux package
and well, nothing "sqlplus" in the zip
RJarett
you grabbed only the basic package then
and not the sqlplus addition for it
you need both
parigaudi
yes indeed the basic package it was
ok
thx
RJarett
youll then edit the tnsnames.ora with the connection information the DBA gave you
than use sqlplus to connect to the db
parigaudi
ok thx
RJarett
and run queries to tell you all the object definition information
MaL0_
hi
which is the correct way to reference two rac machines on the tnsnames of an application server? ( on one line vip-ip --> hostname-vip and on another line: real-ip --> physical-hostname )
is this correct ?
Dormir
MaL0_: might be better to paste an example of what you're talking about. use pastebin
MaL0_
oks
Dormir http://sprunge.us/JVSU
is this a correct hosts configuration on a application server to access two oracle rac nodes ?
zasz
anyone else having trouble downloading the oracle db client from the oracle site
RJarett
nope
« prev next »