Database Administration ( 28 Sep. 2012 )



Different commands relating tablespace were discussed and students do practice 




Create tablespace myspace datafile ‘path \myspace1.dbf ‘ size 10m;
            -this will create a tablespace having name myspace1 and its size will 10Mb
Alter tablespace myspace readonly;
            -this will change the attribute to readonly after this user can only read or view the file
Alter tablespace myspace read write;
            -this will undo the above command now user can read and write data
Desc dba_data_files
            -this will show all colum’s names stored in database
Alter database datafile ‘ path \myspace1.dbf ‘ resize 5m;
            -this will change the size of tablespace to 5Mb which was 10Mb
Alter tablespace myspace offline normal;
-          this will do offline the tablespace
drop tablespace myspace including contents and datafiles;
-          this will delete datafile and its contents having name myspace1
to delete any tablespace first change its status to offline than delete it

Comments

Post a Comment

Popular posts from this blog

Code for Database Connection confirmation PHP+HTML

<html> <head> <title> web page 2</title> </head> <body> <?php error_reporting(0); $con=mysql_connect("localhost","root",""); if($con){     mysql_select_db('one',$con); echo "connection successfully"; } else{     echo "connection fail"; } $id=$_REQUEST['id']; $name=$_REQUEST['name']; $email=$_REQUEST['email']; $password=$_REQUEST['password']; $query="INSERT INTO `db1`.`one` (`id`, `name`, `email`, `password`) VALUES (NULL, '$name', '$email', '$password'); "; $r = mysql_query($query); if($r) {echo "inserted";} else {echo "error";} ?> </body> </html>
Read more

Database connect with php

<?php error_reporting(0); include("db.php"); if($_REQUEST['id'] != ""){ $id = $_REQUEST['id'] ; $del = "delete  from one where id = $id"; $dd = mysql_query($del);     } $q = "select * from one;"; $res = mysql_query($q); ?> <html> <head> <title>3rd page</title> </head> <body> <table border="2" cellpadding="2" cellspacing="2"> <tr> <td>ID</td> <td>Name</td> <td>Email</td> <td>Password</td> <td>Delete</td> <td>Edit</td> </tr> <?php while($row = mysql_fetch_array($res)){ ?> <tr> <td><?php echo $row['id']; ?></td> <td><?php echo $row['name']; ?></td> <td><?php echo $row['email']; ?></td> <td><?php echo $row['password']; ?></td> <td><button onClick=...
Read more

New Slides

Notes of Network Security                             Data Encryption Standard   Click here for for further detail on DES   Assignment of Re search method........ Performance of Windows XP, Windows Vista and Apple's Leopard Computers under a Denial of Service Attack  IT PM slides ...... 6) 4- M ar _ Estimate Cost determine Budget 7) 25-mar-2013 _ Quality management 8) 9-Aprl-2013_Procurement Management     The assignments from lecture slides are following 1) Requirement traceability matrix. 2) WBS 3) WBS Dictionary 4)   Gantt Chart 5) Network Diagram 6) Milestone Chart 7) RACI CHART 8) Organizational Break Down structure   9) Issue Log   Click h ere for Rest of the templates  Please discuss in case of any ambiguity.  
Read more