You maybe could trick the installer mounting a disk as a folder in the C drive.

You just have to find where the installer looks for free space and tries to...

You mean you have Oracle data on the system drive?

Doesn't look like a great idea...

Increase disk space.

2.75 GB free on the system drive is not enough anyway to have decent performance.

No particular permissions required.

The transaction isolation level is not a database setting, it's a connection setting.

SELECT ID, NAME, "ADD"

FROM source

UNPIVOT ( "ADD" FOR col IN (ADD1, ADD2, ADD3, ADD4, ADD5, ADD6));

Given that your table is called source and has the columns (ID, NAME, ADD1, ADD2,...

Also, you didn't provide any table name. Is "source" the name of your table?

vp7986 (8/30/2012)

---

Thanks this example works perfectly...But This is an example i have provided but in real life we have table and columns names.

Can you give me this as columns names...

🙂

Sins of a past life boiling to the surface...

WITH source(ID, NAME, ADD1, ADD2, ADD3, ADD4, ADD5, ADD6) AS (

SELECT 1, 'ABC', '12B', '13B', '14B', '15B', '16B', '17B' FROM dual

UNION ALL

SELECT 2, 'BBC', '10V', 'VCF', 'BB', NULL, NULL,...

Another possible option: http://spaghettidba.com/2011/05/26/changing-server-collation/

You have to set it static before asking for a firewall rule.

Now your port is dynamic, which means that it may change every time the service starts.

Choose a port and,...

The network admins could have opened the default port only.

I suspect you're on...

I would:

1) check if the named instance is reachable from the client machine. You can do that specifying the port number in the "server name" box using a comma: SERVER,port

2)...

Glad you sorted it out!

It should work with CR 9.

Have you tried creating the table?