informatica:oracle:sqlplus
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| informatica:oracle:sqlplus [2015/07/21 06:56] – jose | informatica:oracle:sqlplus [2019/11/06 13:00] (current) – jose | ||
|---|---|---|---|
| Line 3: | Line 3: | ||
| sqlplus "/as sysdba" | sqlplus "/as sysdba" | ||
| + | | ||
| + | Para arrancar: | ||
| + | startup | ||
| + | Para parar: | ||
| + | shutdown inmediate | ||
| + | |||
| Para ver con que usuario estamos conectados: | Para ver con que usuario estamos conectados: | ||
| SQL> show user; | SQL> show user; | ||
| Line 9: | Line 15: | ||
| Saber en que BBDD estoy: | Saber en que BBDD estoy: | ||
| show parameter db_name | show parameter db_name | ||
| + | | ||
| + | Version | ||
| + | SELECT * FROM V$VERSION; | ||
| + | SELECT version FROM V$INSTANCE; | ||
| Espaco tablespaces | Espaco tablespaces | ||
informatica/oracle/sqlplus.1437461786.txt.gz · Last modified: by jose
