Oracle: HOW TO GET TEMPFILE INFORMATION
desc dba_temp_files or desc v$tempfile;
Oracle: HOW TO GET TEMPFILE INFORMATION Read More »
Oracle: HOW TO CHECK THE SPACE IN TABLESPACE
select tablespace_name,sum(bytes/1024/1024/1024) from dba_free_space group by tablespace_name
Oracle: HOW TO CHECK THE SPACE IN TABLESPACE Read More »
Oracle: HOW TO CREATE TEMPORARY TABLE SAPCE
create temporary tablesapce tempfile ‘c:——.dbf’ size 200m;
Oracle: HOW TO CREATE TEMPORARY TABLE SAPCE Read More »
Oracle: HOW TO CREATE TABLESAPCE
create tablespace datafile ‘c:—–.dbf’ size 200m;
Oracle: HOW TO CREATE TABLESAPCE Read More »
Oracle: TO CHECK THE USERS IN A PARTICULAR SCHEMA
select username,default_tablespace from dba_users;
Oracle: TO CHECK THE USERS IN A PARTICULAR SCHEMA Read More »
Oracle: How to ADD DATAFILE INTO A TABLE SPACE
alter tablespace add datafile ‘PATH’ size 200m;
Oracle: How to ADD DATAFILE INTO A TABLE SPACE Read More »
Oracle: How to Export / Import Database Schema
1. EXPORT: exp system@test owner=test123 file=d:oracleuser.dmp log=d:oracleuserdump.log rows=y statistics=none feedback=100 indexes=y consistent=y compress=n; (for individual tables=table1,table2,…..) 2. IMPORT: imp system@test fromuser=test123 touser=test123 file=d:oracleuser.dmp log=d:oracleuser11.log ignore=y rows=y indexes=y feedback=100;
Oracle: How to Export / Import Database Schema Read More »
How to lock / Unlock account in FreeBSD
pw utility is a command-line utility for the FreeBSD which provides ability to locking or unlocking FreeBSD user accounts. FreeBSD locking an account command Syntax: pw lock <username> Example Lock user account named vivek. Login as a root user and type following command: # pw lock xyz FreeBSD unlocking an account command Syntax: pw unlock <{username>
How to lock / Unlock account in FreeBSD Read More »
How To: Remove or hide Acrobat toolbars from an external Acrobat window
In order to open a PDF file in a web browser, without the Acrobat or Acrobat Reader toolbar, you would need to link to the PDF with the following HTML code, where #toolbar=0 follows the .pdf filename: <P><a href=http://www.server-name.com/filename.pdf#toolbar=0&zoom=85>Link without toolbar </a></P>
How To: Remove or hide Acrobat toolbars from an external Acrobat window Read More »
Linux: iSCSI Initiator installation & configration
Installation Instructions: Red Hat Supplied iSCSI Initiator: Find the RPM on the Red Hat Media, then install it using the rpm –ivh command as follows: # rpm –ivh iscsi-initiator-utils-6.2.0.742-0.5.el5 NOTE: This is the version for Enterprise Linux AS 5. Your version may be different. An alternative to installing this package manually in Red Hat Enterprise
Linux: iSCSI Initiator installation & configration Read More »