INDIALOTS

Get latest tech updates, songs, lyrics, oracle issues and vtu notes.

Pages

  • Home
  • Tech
  • Oracle
  • Lyrics
  • Linux Administration
  • Oracle Administration
  • OraHow

Monday, 16 September 2019

Recreate temp tablespace in Oracle

SQL> create temporary tablespace temp1 tempfile '/scratch/u01/app/oracle/oradata/tmp01/temp01.dbf' size 10G;

SQL> alter database default temporary tablespace temp1;

SQL> drop tablespace temp INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.





https://orahow.com/drop-and-recreate-temp-tablespace-in-oracle/
READ MORE ...
Posted by Santosh at 23:41 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

My Blog List

  • orahow
    PostgreSQL Full VACUUM Guide: Improve Performance & Free Space

TRENDZ

Loading...

Search

Popular Posts

  • How to Find Dell Service Tag and Express Service Code using CMD
  • TU HI YE MUJHKO BATA DE LYRICS - Ashique 2
  • Windows: How to Hide/Unhide Hard Disk Partition using Command Prompt
  • Internet Download Manager Free Download with Lifetime Activation
  • Lyrics: Gulabi Aankhein Jo Teri Dekhi Md.Rafi
  • PostgreSQL Tutorial
  • Tere Hoke Rahenge Lyrics - Raja Natwarlal | Arijit Singh

Labels

Tech lyrics oracle Social Faceboook VTU Ashique 2 Lyrics Firefox Jmeter Kishore Kumar Loadrunner MySQL Narendra Modi OS PostgreSQL SQL Software Testing Windows blog free software uid

Facebook

Blog Archive

  • February (1)
  • September (1)
  • December (1)
  • September (1)
  • August (19)
  • July (5)
  • June (9)
  • May (3)
  • April (6)
  • March (1)
  • February (8)

About

Oracle Database and Linux Tutorials

Loading...

Pages

  • Home
  • ORACLE
  • TECH

Tags

Tech (16) lyrics (12) oracle (12) Social (4) Faceboook (3) VTU (3) Ashique 2 Lyrics (2) Firefox (1) Jmeter (1) Kishore Kumar (1) Loadrunner (1) MySQL (1) Narendra Modi (1) OS (1) PostgreSQL (1) SQL (1) Software Testing (1) Windows (1) blog (1) free (1) software (1) uid (1)

Popular Posts

  • How to Find Dell Service Tag and Express Service Code using CMD
  • TU HI YE MUJHKO BATA DE LYRICS - Ashique 2
  • Windows: How to Hide/Unhide Hard Disk Partition using Command Prompt
  • Internet Download Manager Free Download with Lifetime Activation
  • Lyrics: Gulabi Aankhein Jo Teri Dekhi Md.Rafi

CONTACT US

Name

Email *

Message *