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 set a proxy in UTL_HTTP

sanSep 6 2010 — edited Sep 6 2010
Hi,

I am using the UTL_HTTP package there i want to set a proxy .

My proxy address is ex: 102.168.12.12 port is 5678

how to assign these values to utl_http.set_proxy procedure???


Can anyone help me out in this??


Cheers,
Shan

Comments

Paul M.

I had followd PaulM reply

Well, glad that someone reads my posts...:-)

sql>select DEFAULT_TABLESPACE from dba_users where
username = 'test';
It shows no data found.

Try 'test' in uppercase.
See http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements008.htm#sthref723

While creating a user it takes some default
tablespace know?

With XE default tablespace is SYSTEM.

How to assign a Default TableSpace to a user?

As dba or sysfba

SQL> alter user <username> default tablespace <new tablespace>;
senthilmca
Thanks

I am having DBA privleges..

sql>ALTER USER TEST DEFAULT_TABLESPACE SYSTEM;

Is the above query is correct?
It gives ORA-00922: missing or invalid option.
Paul M.
DEFAULT_TABLESPACE
It should be "DEFAULT TABLESPACE ".

But, please do not assign SYSTEM as default tablespace for "normal" users.
senthilmca
Thanks Paul..

Now recycle bin carries dropped objects.

How to retrieve that dropped objects?
I am using Ora10g XE.

I think using FlashBack?

If yes means what are the parameters i have to change in init.ora?.
It is available in C:\oraclexe\app\oracle\product\10.2.0\server\config\scripts.

It is having below parameters..

undo_management=AUTO
undo_tablespace=UNDO
DB_RECOVERY_FILE_DEST_SIZE = 10G
DB_RECOVERY_FILE_DEST = C:\oraclexe\app\oracle\flash_recovery_area

Apart from those params if i add anyother in .ora file?

Thanks
Paul M.
How to retrieve that dropped objects?
SQL> show recyclebin

or you can query USER/DBA_RECYCLEBIN views.

what are the parameters i have to change in init.ora?.
You shouldn't need to change anything.
senthilmca
Thanks Paul

I am able to see the dropped object from Recycle bin.
But i am not able to restore that object using FlashBack.

When i am issuning the below command

sql>flashback table <tblname> before drop;

It shows ORA-00911: invalid character.
I think FlashBack is not enabled in my DB..

Is it correct?
How to remove this error?
Thanks
Paul M.
sql>flashback table <tblname> before drop;
Should be

sql>flashback table <tblname> to before drop;

See http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9012.htm#i2172752
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 4 2010
Added on Sep 6 2010
6 comments
23,168 views