Put your tips and tricks online - Share your knowledge! Login | Register
 
 
  Search     Advanced search
 

Home | Ask Question | Add tip | Questions | My tips | Recent tips & tricks | Suggest a category | FAQ | Forums
Online Tools:  Generate rename / copy datafiles script

 
 
 
 Found 24 tips, Displaying 11 - 20 
 
Sort by 
 
 How to enable autoextend on tablespaces and datafiles
-- Create tablespace with a datafile that will be auto extended to 10Gb create tablespace TABLESPACE_NAME datafile '/path/to/datafile.dbf' size 2000M AUTOEXTEND ON MAXSIZE 10000M extent management local uniform size 5M segment space management auto; If you want to enable autoextend on a smallfile tablespace (if you are trying to alter tablespace to ...
     
More...

06/04/08
 
 
 How to identify semaphors and shared memory for $ORACLE_SID
This is how to find out what shared memory / semaphors are used by a specific Oracle instance, in case you need to clean up shared memory after database crash for example. . oraenv [ORACLE_SID] $ORACLE_HOME/bin/sysresv
     
More...

02/14/08
 
 
 How to move an index to another tablespace
SQL> alter index [index_name] rebuild tablespace [tablespace_name];
 More...
02/11/08
 
 
 How to find out character set for a database
SQL> select * from v$nls_parameters; PARAMETER ---------------------------------------------------------------- VALUE ---------------------------------------------------------------- NLS_CHARACTERSET US7ASCII ...
     
More...

10/25/07
 
 
 Syntax to create database link
Syntax for creating db link in Oracle database: create database link LINKNAME connect to USERNAME identified by "PASSWORD" using 'DBNAME';
     
More...

03/08/06
 
 
 Select random row from Oracle table
Use this query to select a random record from Oracle table. This works from TOAD as well as sqlplus: SELECT col_name FROM (SELECT col_name FROM table_name ORDER BY dbms_random.value) WHERE rownum = 1;
     
More...

02/16/06
 
 
 Kill Oracle sessions from OS level
When shutdown immediate does not work this command may help (replace DBNAME with ORACLE_SID of database you are trying to shutdown): kill -9 `ps -ef | grep DBNAME | grep 'LOCAL=' | awk '{printf("%s ", $2);}'`
     
More...

12/04/05
 
 
 Database copy / restore - skipping tablespaces
Sometimes you want to copy (refresh) database without some tablespaces i.e. due to space restrictions. These are general guidlines for skipping tablespaces when copying a database (the same with RMAN restore, restore from cold backup or copy from a standby database). 1. Once the datafiles have been copied / restored SQLPLUS> startup ...
     
More...

11/14/05
 
 
 Scripts to backup Oracle database on Windows NT
Here's a set of scripts to do database export, full database backup (putting tablespaces in backup mode, not using RMAN) and scan the backup logs on Windows NT. The datafiles are first copied to another filesystem using ocopy and then backuped with ntbackup. You can also see some examples of ...
     
More...

11/03/05
 
 
 Put tablespaces in backup mode
-- -- Sample script to generate start backup and end backup scripts -- for all tablespaces in the database -- set pagesize echo off feedback off verify off spool BEGIN_BACKUP.sql SELECT 'spool BEGIN_BACKUP.log' FROM dual; SELECT 'ALTER SYSTEM SWITCH LOGFILE;' FROM dual; SELECT 'ALTER TABLESPACE ' || tablespace_name || ' BEGIN BACKUP;' FROM dba_tablespaces; SELECT 'ALTER DATABASE BACKUP CONTROLFILE TO ...
 More...
10/26/05
 
 

<< 1 | Page 2 | 3 >>

Recent tips & tricks
Mobile Phones / Tablets > Android : smb not working with Samsung G...
Databases > Oracle > Performance Tuning : When and what's been analyzed
Databases > Oracle > Performance Tuning : Sessions, transactions and rol...
Databases > Oracle > ASM : ASM empty directory doesn't ge...

More categories
Databases | Programming | Hardware | Operating Systems | Networking | Internet | ERP / CRM | Games & Multimedia | Graphics & Design | Miscellaneous | Mobile Phones / Tablets | Office Software
 

Home |  FAQ |  Terms of Use |  Privacy Policy

© 2005 tiplib.com