Oracle resources

[random]

Κατ'αρχην οταν μιλαμε για databases, και oracle, τα 20 mb δεν ειναι πολλά, ειναι ψιχουλα. Και με το κοστος των σκληρων δισκων και των cd ειναι αμελητέα.

 

Υπαρχει ena neo feature της Oracle 9i Rel.2 που λεγεται Compression, αλλα αφορά μαζική εισαγωγή data με τον SQL Loader.

Με τους νορμαλ τροπους INSERT, UPDATE, DELETE ΔΕΝ ΔΟΥΛΕΥΕΙ.

Ειναι για περιπτωσεις που εχεις εκατομμυρια εγγραφες που ομως δεν τα χρησιμοποιεις καθε μερα, και Πολλα GBytes δεδομενων, δεν ειναι για τις συνηθεις περιπτωσεις.

 

περισσοτερα εδω

http://otn.oracle.com/products/bi/pdf/o9ir2_compression_twp.pdf

http://otn.oracle.com/oramag/webcolumns/2003/techarticles/poess_tablecomp.html

 

συμβουλή: forget it.

[dominant]

Telika den mporeis na synde8eis me ton Client 9 ston Database Server 7.

[dominant]

8elo na valo ena arxeio mesa se ena table os BLOB. Ksereis pos einai o sql kodikas?

[dominant]

Meso perl prospa8isa na steilo BLOB ena arxeio kai eleva to eksis munhma la8ous

 

>
DBD::Oracle::st execute failed: ORA-03113: end-of-file on communication channel
(DBD: oexec error) at C:/progs/dika/insert_blob_test.pl line 35.

Execute error: 3113 .... ORA-03113: end-of-file on communication channel (DBD: o
exec error)

 

 

na kai o kodikas se perl

 

>
#!/usr/local/bin/perl

use DBI;

$LONG_RAW_TYPE=24; # Oracle type id for blobs

$dbh = DBI->connect()
	or die "Connecting : $DBI::errstr\n ";


open(BLOB, "file.doc");
$bytes = 0;
       binmode(BLOB);
$bytes = read(BLOB, $buf, 500000);

print STDERR "Read $bytes bytes...\n";
close(BLOB);


$stmt = $dbh->prepare("INSERT INTO hr.documents (documentid , document_name, document) VALUES (hr.autoinc.nextval,'john.doc',?)") || die "\nPrepare error: $DBI::err .... $DBI::errstr\n";


$attrib{'ora_type'} = $LONG_RAW_TYPE;
$stmt->bind_param(1, $buf, \%attrib);  

$stmt->execute() || die "\nExecute error: $DBI::err .... $DBI::errstr\n";

print STDERR "Complete.\n";

 

koitaksa kai edo http://www.orafaq.com/error/ora-03113.htm Ekana restart ton server, anevokatevasa to sid alla to la8os paramenei.

 

Ti allo les na einai, sou exei ksanatyxei?

 

Sumvenei otan ektelo to query me to BLOB.

[random]

Με το θεμα αυτο ειμαι ασχετος. Δεν ξερω Γρι απο Perl, και δεν εχω δουλέψει με BLOBs

 

για δοκιμασε: να κανεις insert ενα αρχειο μικροτερο απο 4000 bytes.

 

δες εδω μηπως εχουν κι αυτοι το ιδιο προβλημα

http://www.xray.mpe.mpg.de/mailing-lists/dbi/2000-07/msg00547.html

[dominant]

Telika to elisa to zitima me to LONG RAW, omos antika8ista epaksia ta BLOBs?

[random]

blob <= 4 Gb, Long_raw <= 2 Gb

kai kapoia alla mikroterhs shmasias. look at Oracle SQL Reference/Basic Elements of Oracle SQL/Datatypes

 

Kapou leei kati gia Locators, isws ekei einai to provlima sou, 'h to perl interface pou exeis (DBI) den synergazetai kala me thn Ora9.

[dominant]

Endexomenos na einai kai problima tou DBI, dbd::oracle (an kai veltionete sunexos).

[dominant]

Na se rotiso, se poio table apo8ukeuontai ta username kai pasword ths vashs? 8elo na ta syndeso me thn efarmogh mou.

[random]

an kaneis login san user "SYS" 8a mporeis na deis ton pinaka "USER$", ekei einai ta usernames, alla ta password einai hashed (as poume san kryptografimena),

den kserw (kai an ginetai) pws na ta deis.

 

ti ennoeis na ta syndeseis?

oti gia na mpeis sthn efarmogh prepei na eisai kai db user?

Den to synistw einai kakos sxediasmos kai provlima asfaleias.

 

Alla an epimeneis, den xreiazetai esy (pou ftiaxneis thn efarmogh) na gnwrizeis ek ton proterwn to user/pass,

arkei na exeis mia login o8onh,

kai na exeis ena check an to login einai petyxhmeno 'h oxi gia na perasei mesa.

 

check also

http://www.experts-exchange.com/Databases/Oracle/Q_20313862.html

 

http://beta.experts-exchange.com/Databases/Oracle/Q_20287822.html

[random]

ta constraint tha xtypisoun mono an anaferontai se pinakes 'h scemata pou den perilambanontai sto import file, ara den mporw na kserw ti ginetai sthn db sou.

 

epishs PROSOXH sta NLS parameters pou 8a dwseis sth nea bash.

eidika to NLS_CHARACTERSET (kai NLS_NCHAR_CHARACTERSET ) na mhn diaferei apo thn palia bash giati mplekeis.

an ftiakseis thn default vash 9i, prepei na ta checkareis ta NLS kai na ta allakseis prin opoiodhpote import.

 

o asfalhs tropos einai na ftiakseis thn 9i, kai na kaneis ta import enw oi efarmoges synexizoun na paizoun sthn 7.

otan sigoureyteis gia ola, paradideis thn 9i ston kosmo.

'h kane test me thn 9i pou exeis spiti sou.

 

pantws prepei na diavaseis ta peri migration prwta, kai ase to import meta. isws ta link pou sou edwsa apantane tis apories sou.

 

vale mou se pm to e-mail sou na steilw kati

[dominant]

Kai o enalaktikos tropos gia migration? ( autos pou xrisimopoieite by default)

 

Murizomai provlima me export kai import ( 8a katafugo se auto an tipote allo den sta8ei ikano na mou kanei th douleia)

[random]

migration = oti lene ta docs.

 

enallaktikos einai to export, import.

[dominant]

HELP!!!

 

Ekana export sto solaris kai parax8ike kanonika ena dump ths takseos ton 150 MB. to ekana cat kai eida oti oi xarakthres kodikopoiountai kala. Otan to peira mesa ftp na to grapso sto CD Win2k Server tote vlepo oti to dumb dialu8ike, parakseno encoding mou vgazei tetragonakia to dump mesa

 

Ti provlima na einai? Mipos to xalaei sto FTP?

[Γηρυόνης]

Το FTP φταίει. Πρέπει να το κάνεις FTP σε binary και όχι σε ASCII αν θέλεις να κρατηθεί η κωδικοποίηση των χαρακτήρων.