Problem Statement: Problem Statement

Examples:

• onspaces -c –P plogdbs -p /dev/chk1 -o 0 -s 40000
• onspaces -c –P pdbs1 -p /dev/pchk1 -o 500 -s 60000 -m /dev/mchk1 0

Note

• If a PLOGspace already exists:
• Creating a new one will create the new PLOGspace,
• Move the physical log to that space,
• Drop the old PLOGspace,
• All of the above done automatically.

Creating a PLOGspace with SQL Admin API

• Creating a PLOGspace with SQL Admin API

• General Syntax:

• create plogspace, ,
  , , , ,

• Examples:

• execute function task(“create plogspace”,”plogdbs”,”/dev/chk1”,30000,0);
• execute function task(“create plogspace”,”plogdbs”,”/dev/chk1”,30000,0,”/dev/mchk1”,0);