Morning

Morning

A chairde - Morning all!

Morning!

Good morning.

Today in fun oracle stuff - Have a statement with a couple of left joins. Runs okay. Add third left join (to a table that definitely exists): "ORA-00942: table or view does not exist". Remove the first table from the query and just join to the others, works fine.

did you pay for the three left join add on?

I have to pay Oracle money to ask that question

nature of oracles

pay to play

Lol, no error if I change it to inner joins

Ok, looks like some issue with using a temp table (which sadly I have to resort to given the lack of keys/indexes on tables I do not own)

everyone tells me those are bad for performance anyway

They're usually just unnecessary and indicative of stupid, stepwise thinking (as opposed to stupid, set-based thinking)

but they're so cute

like little cartoon girls

i have what may be a stupid question

how do i permanently delete the "new volumes" and release the disk space

This is where I use one of those dumb GUI tools because I'm lazy.

like what

I think the free version of DiskPart should be able to delete/merge partitions

The internet also says there is a windows feature "Disk Management" but that could be lies.

that's what that screenshot is from

Gotcha - I think if you right click on the list and select "delete volume" that should do the trick

that just makes the space unallocated

it doesn't permanently delete anything

assume i've done the same basic google search as you 😘

lol

Are you trying to shred the data first or just delete those volumes and expand c?

there's no data on them

Ok, so normally you'd delete the volume (which makes the space unallocated) then reallocate it unless I'm missing something here.

that doesn't delete it permanently

i want it gone

This is the only other method I could find

yes, that just gets me back to having unallocated space though

it doesn't remove the space

it's in disk space purgatory

It looks like you're trying to consolidate the partitions into a single partition. Is that correct?

Are you hoping to have just a C: drive and a D: drive? Or just a C: drive?

no

i want to get rid of empty space

it's just a local vm that i'm downsizing

oh, so you don't care about the E:, T: and F: partitions at all? Or do you need to keep the T: partition?

@ErikDarling If you want to remove the space occupied by E: and F:, but keep C: and T:, then you'd probably need something like Partition Magic, or alternately backup the content of the T: drive somewhere, then blow away E:, T:, and F:. Once you delete the partitions (using either the Disk Management applet or diskpart.exe from the command-line), you should be able to shrink the virtual disk. Is it HyperV or?

yeah it's hyper v

It's also possible that the hypervisor shrink utility will only remove contiguous free space from the end of the virtual disk if the space contains bytes that have been set to 0x0, i.e. overwritten using something like SysInternals secure delete utility.

hrm

I love using Terabyte Image for Windows for this kind of thing because you can take a backup of the disk and restore just particular partitions, and at the same time resize partitions. So, could backup just C: and T:, then create a new empty VHDX file, and restore those partitions into it. Once that completes, delete the old VHDX file.

but for that, you need space. Which it seems like you don't have.

Nothing is ever easy, amiright

Terabyte Image for Windows allows you to preserve the disk signatures, etc, so Windows is none the wiser.

this is way more than i want to get into just to free up some disk space

@ErikDarling Oh maybe I'm assuming you've already tried just shrinking the disk from HyperV - have you tried that and it doesn't work? (I'm assuming you tried it, and it couldn't shrink the disk).

yes

shrinking isn't even an option anymore when i go in there

I heard shrinking is always bad anyway

@ErikDarling Crucial info that would have caused me to say "not my area of expertise"

Have you tried Terabyte Image for Windows

lol

@ErikDarling see this screenshot:

you have to have the VM turned off, not saved.

reeeeeeee

is that good reeeeeee or "Hannah's an idiot" reeeee

there's no such thing as a good reeeeeeeeee

LOL

compact runs for a blip and nothing changes

then you need to zero out the space

i have deleted and formatted and etc and so forth

My cat is mooching my fries and that is seriously not cool

it's especially weird because I was told VMs make everything easier

@ErikDarling have you considered hiring a consultant?

learn.microsoft.com/en-us/windows-server/administration/…

^^^ what does that tell you

also, Erik, I'm beginning to wonder if Service Broker is involved

Brazil 1 Croatia 1

after extra time

Croatia wins 4-2 on penalties

@HannahVernon nothing useful

@ErikDarling as in "I tried it and nothing happened", or "I read the page and couldn't understand what you're on about, Hannah"?

i tried it and nothing happened

that certainly sounds like it believes there is no free space at the end of the vhdx

as a test, you could try expanding the disk by a 1GB or something, then try shrinking to see if can shrink the disk at all.

i figured it out

or rather, i did the same thing enough times that it worked

in disk management, you can shrink a drive down to make the space unallocated

so i did that

then created a volume on the unallocated space

then i deleted the volume

then i expanded another volume over the unallocated space

then i shut down the vm, and it had the shrink option back

so i shrunk the disk down to the smallest it could get to, and then compacted the disk

now it's ~250gb instead of 1.2tb

congratulations :-)

i'm not sure that congratulations are in order for that

Such a pity that I can't watch the soccer - would have loved to have seen Croatia snatch that match at the last minute!

what's keeping you from watching

did your tv license expire

I refuse to sanction in any way whatsoever the disgusting regime in Qatar - I didn't watch the Winter Olympics in China and I"m quite the fan of ice hockey!

oic

understandable

is that a widespread thing?

AIUI, no. I'm disappointed in FIFA and the COI - as far as I"m concerned, championships should only be held in stable democracies - have we learnt nothing from 1936?

Can people please refrain from posting football scores in real time? Not everyone can watch games online and have to resort to on-demand viewing later...

@PaulWhite VM's were a mistake?

Apostrophes were a mistake

Real time score from RTE news deleted...

some of these Advent of Code challenges take me so long that I would be faster if I counted it manually

@ErikDarling Fair.

@Zikato sounds like a powershell problem

Anything is a PowerShell problem if you try hard enough

I'm a few days behind but doing them all in SQL. I do a lot of Powershell, but I always feel SQL is more declarative/expressive with a lot of these problems.

Well, I've got my tinypc and plex set up now

It's a pretty nice looking box, so I shoved it vertically between the DVR box and the NAS

i'm sure it will feel nice and warm and cozy in there

@bbaird show us the code please! You might have accidentally mixed old join syntax with new.

@ypercubeᵀᴹ I never use old syntax because it's not 89 anymore

I was able to trick the query analyzer with two inline views like a schmuck so I'm ditching the temp table for the moment

ok but I said "accidentally". maybe a comma find its way into the code

so no one wants to make a "comma chameleon" joke here

i see how it is

this seems rather unfortunate

data.stackexchange.com/dba/query/edit/1685834

@bbaird it might be some Oracle weirdness with temp tables. No idea