Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Logical Backup : Tablespace level backup

SQL> select name from V$tablespace;

SQL> select name from V$datafile;

SQL> create tablespace ssss

                datafile '/u02/app/oracle/ssss/ssss01.dbf'

                size 10m autoextend on;

SQL> grant connect,resource to u1 identified by u1;

SQL> alter user u1 default tablespace ssss;

SQL> conn u1/u1;

SQL> create table a(a number(3));

SQL> insert into a values(1);

SQL> /

                repeat for many times.

SQL> commit;

SQL> select count(*) from a;

oracle logical> exp file=ts.dmp log=ts.log tablespace=ssss

                username : / as sysdba

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Flag Counter