AbdulWasiq

Pages

  • Home
  • Basic
  • Linux/Unix
  • Interview Questions
  • Scripts
  • Real Time Scenarios
  • Fresher Alerts Monitoring job
  • RAC
  • Patching
  • Metalink Id's
  • Installations
  • Presentation
  • About Conc Manager
  • RMAN/DATAPUMP
  • Sysadmin
  • Weblogic/SOA
  • Postclone steps
  • Links

Links



What is a tablespace ?
What is a datafile?
How a Tablespace Is Related to Data Files?
How a Database Is Related to Tablespaces?
How To View Tablespaces in the Current Database?
How To Create a New Tablespace?
How To Rename a Tablespace?
How To Drop a Tablespace?
What Happens to Data Files If a Tablespace Is Dropped?
How To Create a Table in a Specific Tablespace?
How To See Free Space of Each Tablespace?
How To Bring a Tablespace Offline?
How To Bring a Tablespace Online?
How To Add Another Datafile to a Tablespace?
How to Remove Data Files before Opening a Database?
How to clone a table?



Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Home
Subscribe to: Posts (Atom)

Total Pageviews

Followers

Page Statistics

Blog Archive

  • ▼  2025 (46)
    • ▼  January (46)
      • Steps to enable user login auditing
      • rman rac duplicate with catalog and archive
      • RMAN Backup script
      • Recovering database till PITR.
      • RMAN DUPLICATE / CLONE RAC DATABASE
      • Getting archives from our tapes to backup location...
      • Create standby from backup base location
      • rman duplicate command
      • rman rac compressed database backup along with con...
      • Take RMAN backup on desire location
      • Script to take backup of schemas and objects
      • Script to take backup of multiple schemas.
      • Find old database backup objects and delete them t...
      • Database Health Check Script
      • Transfer file from Linux server to Windows server
      • Script to transfer file windows to Linux server
      • Script to take backup of schema
      • Take backup of schema using data pump utility ,,, ...
      • Query to display Non Default Oracle Database users
      • Compile invalid objects for a particular schema
      • Last10 execution of the SQL query
      • Script to check locks in the database
      • How to disable Auto Task Tunning jobs...
      • Script to take backup of multiple schema using she...
      • Monitoring Data pump Jobs
      • Backup Database Link Before Cloning & create them ...
      • Script to remove archives from Solaris Operating s...
      • Synonyms without a prefix or accessing the object ...
      • Database Features Usage
      • Script to remove archives
      • Script to move files to another directory
      • Gather Stats for schemas
      • Health Check SQL Queries
      • Script to find temp tablespace free and used space
      • Script to check all tablespace details in the data...
      • Script to find top10active jobs in database.
      • Script to check tablespace details.
      • To find information about locks in the database
      • Check the size of different pools in database usin...
      • Solaris tar and untar commands
      • Change database global name
      • Linux tar and untar command
      • setup ssh
      • How to to find out toad session
      • How to get encrypted password of a user.
      • How to remove archives for a specific date?
  • ►  2019 (79)
    • ►  May (13)
    • ►  April (53)
    • ►  February (13)
  • ►  2017 (1)
    • ►  April (1)
  • ►  2016 (56)
    • ►  November (38)
    • ►  October (5)
    • ►  May (5)
    • ►  March (3)
    • ►  January (5)
  • ►  2015 (43)
    • ►  August (4)
    • ►  May (2)
    • ►  April (24)
    • ►  March (9)
    • ►  February (1)
    • ►  January (3)
  • ►  2014 (110)
    • ►  July (6)
    • ►  June (5)
    • ►  April (32)
    • ►  March (12)
    • ►  February (8)
    • ►  January (47)
  • ►  2013 (172)
    • ►  November (3)
    • ►  October (14)
    • ►  September (30)
    • ►  August (16)
    • ►  July (18)
    • ►  June (28)
    • ►  May (16)
    • ►  April (23)
    • ►  March (11)
    • ►  February (13)
Powered by Blogger.