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.txt · Last modified: 2019/11/06 13:00 by jose