Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to use return statement in procedure?

833557Feb 1 2011 — edited Feb 2 2011
Hi All, still we didn't use return statement in procedure but you know may use return statement in procedure, please give example, your suggestion would be greatly appreciated.

Comments

Prathmesh B
Hope this will help you.

You need to use Transportable Tablespace Via RMAN.

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/dbxptrn.htm
Santosh Kumar
S.Nayef wrote:
Hi:
I have a production server (OS:Windows Server 2003 64-bit, DB: Oracle 11g (11.1.0.7.0) 64-bit) I maintaining RMAN backups on it. I have also a test server 32-bit.
Is there any consequence of installing Win server 2003 32-bit with oracle 11g 32-bit on test and restore the production backup. If any,is there extra procedures I have to do.
Furthermore, does it ease my job (if possible) if I installed Win Server 2003 64-bit and Oracle 11g 64-bit on the test server?

Saad,
They have same endian, so you can use RMAN convert command. That is described in above link given by Prathmesh.
SQL> col PLATFORM_NAME for a35
SQL> select * from v$transportable_platform;

PLATFORM_ID PLATFORM_NAME                       ENDIAN_FORMAT
----------- ----------------------------------- --------------
          1 Solaris[tm] OE (32-bit)             Big
          2 Solaris[tm] OE (64-bit)             Big
          7 Microsoft Windows IA (32-bit)       Little
         10 Linux IA (32-bit)                   Little
          6 AIX-Based Systems (64-bit)          Big
          3 HP-UX (64-bit)                      Big
          5 HP Tru64 UNIX                       Little
          4 HP-UX IA (64-bit)                   Big
         11 Linux IA (64-bit)                   Little
         15 HP Open VMS                         Little
          8 Microsoft Windows IA (64-bit)       Little
          9 IBM zSeries Based Linux             Big
         13 Linux x86 64-bit                    Little
         16 Apple Mac OS                        Big
         12 Microsoft Windows x86 64-bit        Little
         17 Solaris Operating System (x86)      Little
         18 IBM Power Based Linux               Big
         20 Solaris Operating System (x86-64)   Little
         19 HP IA Open VMS                      Little

19 rows selected.
Regards,
S.K.
Saad Nayef
Thanks,
What if I want to leave everything in the production server as it is (backups and dump files). What should I do?
I have the test 32-bit machine as test server, what are the recommended OS and DB platforms to be installed?
If I want to maintain a test server (mostly for checking backups), is it much better if I have the same OS and DB platform?
Sorry for those questions but I have to make the best possible decision.

Saad,
CKPT
Hi,

You are migrating just from 64bit to 32 bit and not even other OS migration. so
You need to use only export/import(effficient method).


for more information on 32 to 64bit
If in case of 32 bit to 64bit migration you can simply run catupgrd.sql script then it will take care.
How to Migrate Oracle 11.1 32bit to 11.1 64bit on Microsoft Windows [ID 817715.1]
1 person found this helpful
Saad Nayef
I'll be frequently checking backups(backup sets and dump files) from the production server (without modifying the original backups).
So, should I do migration every time?
Or should think about having a duplicate server of the production server.

Saad,
Pavan Kumar
Hi,

Frequently carry out migrations makes your job tedious. AFAIK, having a backup server in your case it would be better.

- Pavan Kumar N
CKPT
I'll be frequently checking backups(backup sets and dump files) from the production server (without modifying the original backups).
So, should I do migration every time?

i had upgraded from 32 to 64 but no such practical knowledge on migrate from 64bit to 32bit... but it is alwasy export/import is effecient menthod...

in the process of testing you can restore ..... lets see if any isses then you can downgrade the database(catdwgrd.sql)
I'm not sure it can restore or not using RMAN but this method not at all suggested.... lets test....
Or should think about having a duplicate server of the production server.
it is depends on customer ready to place new server? is yes then no issues
Saad Nayef
Thanks all:
Just for now till we have the budget to get a duplicate server, can I install Windows Server 2003 64-bit with Oracle 11g 64-bit on my *32-bit* machine with now extra efforts........ :) ?

Saad,
CKPT
Just for now till we have the budget to get a duplicate server, can I install Windows Server 2003 64-bit with Oracle 11g 64-bit on my 32-bit machine with now extra efforts........ ?
Then you have to go for export/import you need to either put efforts or put money..
1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 2 2011
Added on Feb 1 2011
7 comments
1,769 views