https://luminoussheep.net/mediawiki/index.php?action=history&feed=atom&title=Oracle_Admin
Oracle Admin - Revision history
2026-05-11T19:21:04Z
Revision history for this page on the wiki
MediaWiki 1.43.8
https://luminoussheep.net/mediawiki/index.php?title=Oracle_Admin&diff=77&oldid=prev
Martin: Created page with "= auto login = export ORACLE_SID=sid sqlplus user/password@tnsName = add permissions to user to connect = grant resource,connect to user; - full permissions = output to f..."
2021-09-14T21:37:05Z
<p>Created page with "= auto login = export ORACLE_SID=sid sqlplus user/password@tnsName = add permissions to user to connect = grant resource,connect to user; - full permissions = output to f..."</p>
<p><b>New page</b></p><div>= auto login =<br />
<br />
export ORACLE_SID=sid<br />
<br />
sqlplus user/password@tnsName<br />
<br />
= add permissions to user to connect =<br />
grant resource,connect to user; - full permissions<br />
<br />
<br />
= output to file =<br />
spool <filename><br />
spool off<br />
<br />
<br />
= killing session =<br />
select * from U$session where username="user";<br />
<br />
alter system kill session "sid,serial#";<br />
<br />
= Dump database =<br />
<pre><br />
exp user/password@sid FULL=y FILE=file.dmp<br />
imp user/password FIlE=file.dmp [FROMUSER=user]<br />
</pre><br />
<br />
= show constraints = <br />
http://en.wikibooks.org/wiki/Oracle_Programming/SQL_Cheatsheet#Displaying_Constraints<br />
<pre><br />
SELECT<br />
table_name,<br />
constraint_name,<br />
constraint_type<br />
FROM user_constraints;<br />
</pre></div>
Martin