notas:bases_de_datos
Diferencias
Muestra las diferencias entre dos versiones de la página.
Ambos lados, revisión anteriorRevisión previaPróxima revisión | Revisión previaPróxima revisiónAmbos lados, revisión siguiente | ||
notas:bases_de_datos [2010/09/24 18:22] – cayu | notas:bases_de_datos [2011/07/04 13:36] – cayu | ||
---|---|---|---|
Línea 201: | Línea 201: | ||
- | ==== Importar CSV ==== | + | ==== Importar/ |
- | Ejemplo | + | Importacion |
<code sql> | <code sql> | ||
LOAD DATA LOCAL INFILE ' | LOAD DATA LOCAL INFILE ' | ||
Línea 211: | Línea 211: | ||
(nombre, pass, usuario); | (nombre, pass, usuario); | ||
</ | </ | ||
+ | |||
+ | Exportacion : | ||
+ | <code sql> | ||
+ | SELECT * FROM usuarios ORDER BY date DESC | ||
+ | INTO OUTFILE " | ||
+ | FIELDS TERMINATED BY ',' | ||
+ | ENCLOSED BY '"' | ||
+ | LINES TERMINATED BY ' | ||
+ | </ | ||
+ | |||
+ | |||
+ | ===== Oracle ===== | ||
+ | |||
+ | |||
+ | ==== Oracle XE issues ==== | ||
+ | |||
+ | Oracle xe must be the buggiest free counterpart of a commercial product ever released.Here' | ||
+ | |||
+ | * I don't set up it to be started upon boot (don't want this bag of bugs eat my memory) | ||
+ | * change the default apex port from 8080 to smth else | ||
+ | * use 8+ characters for sys/system password | ||
+ | * check status of the DB: $ sudo / | ||
+ | * start the DB - I use restart just to be sure: $ sudo / | ||
+ | |||
+ | Q: After installing and sourcing / | ||
+ | |||
+ | |||
+ | > ORA-12519, TNS:no appropriate service handler found | ||
+ | |||
+ | |||
+ | A: Run the following statement from sqlplus or web admin (you should have it accessible due to above tips) | ||
+ | |||
+ | |||
+ | > ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE; | ||
+ | |||
+ | |||
+ | Found [[http:// | ||
+ | |||
+ | |||
+ | Q: How to remove oracle user from ubuntu desktop login screen. | ||
+ | |||
+ | A: Change the oracle' | ||
+ | |||
+ | |||
+ | $ sudo usermod --gid 999 oracle | ||
+ | |||
+ | After that change the ownership of the files in /var/tmp/. | ||
+ | |||
+ | oracle$ sudo chown -R oracle:dba / | ||
+ | |||
+ | or you won't be able to start the DB anymore :) | ||
+ | |||
+ | |||
+ | Q: Cannot open Oracle web interface, Page cannot be displayed. Used to work before, and the DB is working. | ||
+ | |||
+ | |||
+ | A: Might happen especially if you selected to start the DB manually rather than on each boot. The symptoms might be a bit different, the DB might be started or might be not. Some services just fail to start. | ||
+ | |||
+ | Try restart : | ||
+ | |||
+ | $ sudo / |
notas/bases_de_datos.txt · Última modificación: 2013/09/13 14:21 por cayu