Oracle resources

[random]

new, mdb.

dexi klik sta tebles, new / Link Tables

files of type: ODBC Databases

 

new data source, me driver odbc for Oracle (sinh8ws egka8istatai me thn access, alliws kane change sto setup gia na ton pros8eseis, h vres sto internet)

 

ftiaxneis ena data source, pou "dixnei" thn oracle sou, me user, pass, IP, klp...

 

mh rwthseis pws ginetai to odbc setup.. yparxoun ekatommyria phges..

[dominant]

An kano uninstall to TOAD 8a mou svisei kai tous pinakes pou evale sto sxhma pou me endiaferei ?

[random]

oxi, mh me trelaineis...

ti sxesh exei mia efarmogh windows, me ta data ths oracle sou?

[dominant]

Mo evale kati pinakes sto schema pou me endiefere QUEST_... alla tespa, auto den einai provlima.

 

Exeis asxoli8ei me formes kai application developing? (Developer 2000?)

[random]

aaa! oi pikanes quest_klp.. einai epidh epelekses na xrhsimopoihseis ena feature tou toad, peri oracle tuning..

mporeis na toys svhseis, einai gia poly proxwrhmena, den ta xreiazesai

 

forms? oooouuuu, olh h Ellada me ayta asxoleitai

ki egw mazi.

An den exeis asxolhuei pote, 8a ta vreis mpastounia, pare kana vivlio (den yparxoun kai polla)

[dominant]

1) Tutorials apo to internet de mporo na vro?

 

2) Kati para polu shmantiko.

 

An doso export sto 7.3.3 server os ekshs

>
exp system/password full=y consistent=y file=export.dmp log=export.log

 

Tote 8a ginei export ton panton (ok?)

 

An er8o sthn 9.2.0.1 kai trekso to catalog.sql

me apotero skopo vevaia na (kano kuriolektika copy) th vash 7.3.3. sthn 9.2.0.1

 

8a to katafero dinontas to parakato

>
imp system/password file=export.dmp full=y consistent=y log=export.log

??

[random]

1. gia forms exw psaksei kai poly liga.. go google

 

2. den kserw, dokimase na deis, kane ena backup ths 9, kai kane oti 8eleis import mexri na skasei...

 

egw den katalabainw ti nohma exei to full export.

mhpws exeis xiliades xrhstes sthn vash? de nomizw.

 

an kaneis full, 8a pareis kai tous default xrhstes (sys, system, kai kati allous,) pou hdh yparxoun sthn 9i kai den prepei na tous kaneis overwrite tipota.

 

egw 8a ekana export mono tous xrhstes pou ftiaxthkan meta thn egkatastash, tous dikous mou, gia na paizoun oi efarmoges. Ton sys ti na tonkanw?

[dominant]

Exo to full export (nai exo polous users) trxo to import san sys as sysdba alla de ftiaxnei tous neous users pou uparxoun sto export, mipos ksexno kamia parametro?

[dominant]

kamia idea?

 

Kai kati allo. Otan ekamna import ton user pou periexei ousiasthka th vash mou ta triggers pou exei mou xtupane merika apo auta. Koitaksa pou einai to la8os

>to table or view v$session den uparxei

 

Parathro pos uparxei ston SYS table tetoio alla dystixos de to vlepei o trigger(ton ekana compile)

[random]

mallon o user pou exei ton trigger den exei dikaioma na dei ton v$session.

 

san sys,

dwse

grant select ton pinaka ('h view den kserw ti einai) v$session ston user

 

'h oti allo dikaioma apaitei o trigger (insert, klp)

[dominant]

exontas loggarei os system as sysdba edosa

>
SQL> grant select on v$session to my_user;
grant select on v$session to my_user
               *
ERROR at line 1:
ORA-02030: can only select from fixed tables/views


SQL>

[random]

το πραγματικό προβλημα δεν ξερω που οφείλεται αλλα μια προχειρη λύση ειναι

 

GRANT SELECT ANY TABLE to my_user;

[dominant]

telika to elusa to provlima, epsaksa mia allh opsh pou anaferete sthn v$session einai h v_$session.

 

Resy exo provlima me tis formes (einai ftiaxmenes apo developer/2000 kai de mporo na ths kano compiler me developer 6i )

[random]

oi formes exoun .fmb (source) kai .fmx (executable compiled)

an exeis ta fmb, den mporw na bo8u8sw

 

'η θα βρεις τον developer2000 ή θα κανεις τις απαραιτητες αλλαγες

(παντως μου φαίνεται πολυ περίεργο να μην γινονται compile me 6i )

 

αν εχεις τα fmx, πες να σου δωσουν τα sources.

[dominant]

To na vro ton developer 2000 einai ekseretika duskolo, edo to runtime epsaxna (kai de vrika tipota)

 

Exo kai ta sources kai ta executables kai tora koita pos 8a kano re-compile sth consola.