logs archiveIRC Archive / Freenode / #oracle / 2010 / June / 30 / 1
tsyd
do i need oracle-xe installed to install the cx_oracle python driver?
xiaoshen
hi all^^
help me to understand this select 'drop table '||table_name||' cascade constraints;' from user_tables;
select 'drop table '||table_name||' cascade constraints;' from user_tables;
TheBonsai
it generates code you can copy&paste (or EXECUTE IMMEDIATE in pl/sql) or look at it or draw colored or change afterwards or dance with it
sorry, still not enough coffee...
xiaoshen
TheBonsai: tHQ
i have tried it it generates drop table script for all tables
:)
TheBonsai
yes, that's its purpose. it only generates text
xiaoshen
i got it now :)
TheBonsai can u give me another examples that similar with that script?
TheBonsai
SELECT 'ALTER INDEX "' || INDEX_NAME || '" REBUILD;' FROM USER_INDEXES;
or so
whatever you think you need
it is ONLY TEXT
xiaoshen
what its function?
Rebuild?
i don't understanf
i just try this SELECT 'DROP SEQUENCE "' || SEQUENCE_NAME || '" ;' FROM USER_SEQUENCES;
it's correct ?
TheBonsai
for example, yes
         

xiaoshen
ha ijust figure it myself just try maybe it can generates drop sequence script :P
mgolisch
any idea why some job scheduler external jobs randomly fail
ORA-27369: Job vom Typ EXECUTABLE nicht erfolgreich mit Exit-Code: Key has expired STANDARD_ERROR="/ocfs2/load.sh: line
11: /bin/sqlldr: Datei oder Verzeichnis nicht gefunden"
seems like its missing its env
bofur
.
sorry wrong channel
hubidubi
hi
blackcat73
hi, I'm trying to convert an application from postgresql to oracle and need some help with maybe a table of comparision so I can convert the queries
can anyone point me a url that can help me on this?
xiaoshen
blackcat73, i have done from db2 to oracle
usn_work
good afternoon
dddh
morning usn_work
g10k
hi
it's possible to import in a db one dump of db in a single owner/schema
?
i think is possible with exp/imp datapump but i don't know
how :)
usn_work
g10k, you want to import multiple schemas into one schema?
(Action) thinks that SSD are made for a DBA's notebook
g10k
usn_work no
just one
usn_work
look at REMAP_SCHEMA in impdp help
g10k
thx
:)
impdp / REMAP_SCHEMA=OLD_OWNER:NEW_OWNER REMAP_TABLESPACE=OLD_TS:NEW_TS...
i suppose
many Thx usn_work
usn_work
no problem. A suggestion: Use a parameter file (parfile)
it makes life easier
http://www.usn-it.de/index.php/2010/06/30/extracting-ddl-redo-logs-ddldump/
cool stuff, that
TheBonsai
11.2 instance crashing at startup when starting ASMB (SEGV). same config/init/... worked before (had a RAID error crash in the meantime). anybody seen that?
Rudemeister
hi
TheBonsai
m00
eoliva
Hi, I'm trying to use oracle with C under linux, in my development machine, it works well...I use the program and there is no errors. But when I run it on another machine, it crashes. It only work with valgrind, some said me that it should be a race condition. But my environments are almost equal. Does anybody have some knowledge to guide me just to make a query in the database? My db_test file is: http://codepad.org/9IugFtgw
usn
.
« prev next »