logs archiveIRC Archive / Freenode / #oracle / 2010 / January / 24 / 1
I guess it's finally over... Sun is gone.
greetings gentlemen
i really would like to understand what is happened : i have sql*loaded a 3GB CSV file table, into oracle 11G yesterday night, this morning (7 H later) i still didn't get the prompt back, so i decided to connect the database, and i get this error : ORA-00257: archiver error. Connect internal only, until freed.
google said it deals about out of space
with redo logs
sidh check the alert log
sidh: and the harddisk space :D
the alert log should tell which FS ;)
what is the recommended OCP book?
hi, i have a problem regarding nested tables and inheritance, basically i have something like this:
create type Super as object (..); create type Foos as table of Foo; create type Sub under Super (foo_list Foos);
now i have to create a table of Super and dont know how to sepcify the name of the nested table foo_list for Sub...
create table t_super of Super ... nested table foo_list store as... ?
or any idea where to read documentation?
i need your help, because of my redo log too big , i have no disk space left , and i can not connect as sysdba to the db to see where are the redo log files and delete them
due to no left space , i can not connect to the database, i need to know where are the redo log to delete them, how can i do ?
check your init.ora
for log_archive_dest
also, check your filesystem. if there's one that's full, that would be the first one to look at

yes i found the FS
but i don't know where are stored the redo logs
i don't have log_archive_dest
you really need help on how to look through a filesystem?
look through there, move some large files out
i tried some du - a /home/oracle | sort -n -r | head -n 10
also, you should be able to connect / as sysdba
which will get you in and allow you to find what you're looking for
ah, you said you tried that
Dormir: i found a lot of file named arch1_number_708808186.dbf
that have been created last night when i was sql loading data , do you think it could be that files ?
when i strings the spfile , i can see *.log_archive_format='%t_%s_%r.dbf'
ok i read %r are resetlog id , and every file with the same resets_logs id are all from the same database
so i can delete *708808186.dbf
well, I would recommend backing them up
but if you don't need to recover the database, you can delete them
that's ok
it is a blank database in wich i load csv table
you can put the db into noarchivelog mode to load the data
what is better , as i have to load huge CSV files, put UNRECOVERABLE in my SQL*Loader ctl files , or put my database in NO_ARCHIVELOG mode directly ,
oops Dormir we thought to the same thing
if you're not worried about recovery, then noarchivelog mode will do
ok i will put it in the noarchivelog mode then
thank you very much
In France it is time for drink a beer with some snacks food, so i will drink my beer to your cheers
have some rum for me
no my passion is for Belgian beers
In sqlplus, is there a way to default the schema? i.e. say "all future CREATE/SELECT/whatever operations will apply to schema XYZ not my own schema?" to prevent me having to write XYZ. before every object name
TomJ: The connection information you provide has this detail. It's associated with the user you connect as.
TomJ: You could re-connect as another user.
OK, I thought there might be a way to shortcut the creation of objects in another schema without changing user. thanks
another question: How can I suppress the printing of "new: ... old: ..." when a &variable is substituted?
I've looked through every SET option and can't see one
oh there it is, set verify off
Tom: there's a way to change the schema your SQl refers to, but I can't remember it off the top of my head. something like alter session set current_schema
yep, that's it. http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2012.htm#sthref4517
hi guys... If you had a select like ... ... select functionX( a.node ) from Nodes a;
and this functionX returned a string like '1,3,4'
can I split this string into a SQL that is returning me separate rows ?
I need the function to be in the select clause though
wondering if this is possible?
anyone got any ideas?
« prev next »