logs archiveIRC Archive / Freenode / #oracle / 2009 / December / 17 / 1
xep
why does defaultNChar=true make it so I can't enter data into CLOBs using the OracleResultSet from an INSERT x INTO foo VALUES (EMPTY_CLOB()) RETURNING x INTO (?) type of statement?
if defaultNChar=false it works just fine
I can write to an NCLOB with defaultNChar=true but not a CLOB =\
normally inserting values into the clob (i.e. INSERT INTO foo VALUES (?)) works fine.
this is on a 10g DB with latest 10g JDBC driver -- tried with OCI and Thin
no exceptions raised -- just silently leaves my CLOB empty.
Newbie
i am trying to check the total size of my db
http://pastebin.com/m511d3bb7
used this query
its giving me error
from sys.v$log ) c
*
ERROR at line 7:
ORA-00942: table or view does not exist
TheBonsai
who are you?
isn't v$log a public synonym?
Dormir
yes, but isn't viewable by all unless O7_DICTIONARY_ACCESSIBILITY is set
Newbie
TheBonsai, i am new user of oracle,
i am not much aware of it
pls tell me how to check the complete size of db
mvno_subscriber
hi, i have a PL/SQL function that returns a sys_refcursor. However, I can't find out how to use this from another PL/SQL procedure? I can fetch the result of the function but not iterate through it.. can anybody help? I'm using Oracle 9i
usn_work
good morning
Reign1
whats the best way to clear data only from the table? delete or truncate?
usn_work
do you need it transactional?
Faster is TRUNCATE, but without undo/redo security
         

TheBonsai
m00 usn
usn_work
m00 TheBonsai
telles
hi, any one know about the use of multithreads in Solaris with Oracle?
any clue?
ChrisMcA
Hi, anyone installed the Oracle Instant Client on Solaris 10?
mator
telles, what do yo mean?
telles
mator: want to know if enable multithread is better or no, and when...
Reign1
whats highwater mark?
corpsicle
hello
is "oracle.pool.minlimit" an actual oracle/jdbc parameter ?
trasz
are joins with REFERENCES clause faster than without it?
phimic
hello all
someone can explain this error "ORA-03113: end-of-file on communication channel"
CSS, CRS, EVM are healthy, nodeapps and asm are running
usn_work
~> oerr ora 03113
03113, 00000, "end-of-file on communication channel"
/ *Cause: The connection between Client and Server process was broken.
/ *Action: There was a communication error that requires further investigation.
/ First, check for network problems and review the SQL*Net setup.
/ Also, look in the alert.log file for any errors. Finally, test to
/ see whether the server process is dead and whether a trace file
/ was generated at failure time.
phimic
usn_work: i tried to connect with "sqlplus / AS SYSDBA" and did a startup
usn_work: both ora.rac*.vip are Online
usn_work
alert log?
phimic
usn_work: where to find DB_HOME/logs ?
usn_work: sudo find / -name alert.log returns nothing
usn_work
what's your bdump directory?
phimic
usn_work: good question ;)
usn_work
show parameter dump
phimic
usn_work: RA-03114: not connected to ORACLE :D
usn_work: i i think i have it
df -h
sorry wrong terminal
usn_work: ok i have it
it points me to a file *_diag_23912.trc
usn_work: this file is long and very ugly :(
Reign1
if i only wanna clear table from data, its truncate table table_name drop storage; or?
usn_work
yes
         

corpsicle
hey
when creating a stored procedure i get a compiler error saying that the cursor cannot be a number
which is true
but we didnt declare a cursor attribute
if you dont declare one, is one of the columns automaticly a cursor attribute ?
monk12
any use oracle and php, had a question on oci_bind_by_name that i didnt see answered well on google
I am trying to set the length parameter in that function (to set the size for the input and output strings) but its complaining too short or large, not sure what it perfect. -1 doesnt work ...
i set it to 106 and it says ORA-06502: too small, set it to 107 and says ORA-12899: too large lol
Reign1
how to know which foreign key is causing problem? ORA-02297: cannot disable constraint (IRMS.CARD_PK) - dependencies exist
sidh
greetings gentlemen
i have just migrate a 13 GB MSSQL DB to oracle 11g, and i would have 2 questions:
1/ for the migration i had to use a specific schema and the USERS/TEMP tablespaces, now i need to create new tablespaces and a new user , and move the table onto that new tablespaces that belong to the new user
does the new tablespace have to bleong to the migration user too ?
2/In the sqlplus web app (isqlplus) all accentuated char in records are replaced by square, the NLS parameters on the database are FRENCH.FRANCE_AL32UTF8, what do i have to do for having accent (i tried changing the browser enconding, but still the same) ?
Dormir
tablespaces don't belong to users. users have quota on tablespaces
not sure about the character set for the database
well, for isqlplus
if you want a new tablespace for the new user, create it a tablespace and either 1. grant select on the table to the new user and create table as select or 2. export the table and import it as the new user
sidh
Dormir: i would like to create different tablespace with different extent size (8MB,16MB,32MB,64MB,128MB,256 MB, and so on) and dispatch the tables regarding their sizes, but when i look at the tables section of my migration schema, the last analyze is yesterday and i would like to refresh that, do you know how ?
Dormir
not sure how those are related...
you can set the default extent size when you create the tablespace
to analyze tables, use DBMS_STATS.GATHER_TABLE_STATS
there's a default job that will do the analyze every night if the table has changed 10+%
sidh
yes in the 10g dba handbook they learn how to create tablespace
yes but i can not wait for the next analyze
and of course it has changed, before it was 0 and now it is 13 GB
;)
Dormir
ok, use that procedure
Spec
google for the dbms_stats package
sidh
ok thank you very much
Spec
and it'll tell ya all sorts of info about collecting statistics and such
sidh
Dormir: ok , I've created my tablespace, my new user , so when you say "export the table and import it as the new user
do you mean with exp or expdp ? do we really need to export them as file , isn't there a way to do that "internally"?
boingolov
sidh, you could do a database link import with impdp
to avoid the intermediate file
sidh
ok thank you
boingolov
then do the remap_schema , remap_tablespace etc
sidh
boingolov: i don't understand as sys dba i granted new user for database link , but when , as new user , i create a database link, i get a unsifficiant privilege error , any idea ?
boingolov
dish, grant create database link to target user, log in as target user, create database link to source schema on source db (even if source db is same)
sidh
ci05maise
oops
i typed : creta database link mylink connect to old_user identified by old_pwd using 'mydb';
create
and i still get the error
TheBonsai
the user definitely has the grants to create private dblinks?
sidh
TheBonsai: i did this grant separately from sys schema, and now it works
thanks
« prev next »